SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Password at DB level
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

vishu_av
Yak Posting Veteran

69 Posts

Posted - 03/10/2008 :  02:33:54  Show Profile  Reply with Quote
Hi All,
i am the SA user for the SQL server.
Now can i set the password at the Database level?
I donot want create USERS and grant them permissions
I wish to explicitly create password for a database in my server.

Thanks in advance.

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 03/10/2008 :  12:00:29  Show Profile  Reply with Quote
Why you wanna create password for database? Nor sure i understood your question. Please elaborate.
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 03/10/2008 :  22:30:41  Show Profile  Reply with Quote
Take look at application role.
Go to Top of Page

vishu_av
Yak Posting Veteran

69 Posts

Posted - 03/11/2008 :  02:42:07  Show Profile  Reply with Quote
The situation is that, Whoever access the SQL server uses same SA username and password and that we donot have users created for our server here.. Sounds absurd but thats how it is here in our work place.
Therefore was just curious to know if a SA can set password at DB level.
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2067 Posts

Posted - 03/11/2008 :  08:39:56  Show Profile  Visit jackv's Homepage  Reply with Quote
Not quite sure what you're asking , are you asking if the "sa" can have more than 1 password , and each password would give different access to different dbs?


Jack Vamvas
--------------------
Search IT jobs from multiple sources- http://www.ITjobfeed.com
Go to Top of Page

elancaster
A very urgent SQL Yakette

United Kingdom
1208 Posts

Posted - 03/11/2008 :  09:09:28  Show Profile  Reply with Quote
i think i see what you mean...

so everyone logs on as SA, you then want to 'password protect' a database in the same way as you would a spreadsheet for example..? NO, you can't

Em

Edited by - elancaster on 03/11/2008 09:10:04
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 03/11/2008 :  23:23:42  Show Profile  Reply with Quote
Create sql login for each user, never let them use sa.
Go to Top of Page

vishu_av
Yak Posting Veteran

69 Posts

Posted - 03/12/2008 :  02:16:52  Show Profile  Reply with Quote

Elancaster got that right..

I guess i need to create users and have no choice.. :-(
Thanks to all for your valuable advice.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.14 seconds. Powered By: Snitz Forums 2000