We help IT Professionals succeed at work.

sql server - how to set password before allowing access to db

uzairp
uzairp asked
on
Medium Priority
227 Views
Last Modified: 2011-09-20
Hi Experts,
I want to set a password so that a password is required before anyone can see the tables or stored proc in an sql server 2000 db. It is on a win xp pro environment. How can I do that using EM. Thanks in advance for help
Comment
Watch Question

CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
disabled the public access.  Lookinto the login/security/users in EM.  Disabling the Windows login access into the SQL is another approach.
In the SQL Server Enterprise Manager, browse to the Security\Logins section. Add any number of accounts that you would like to have. For each created account, open the account properties, and from the Database Access tab, specify the databases that this account can access, and then for each selected database, specify the database roles allowed for this account on this specific database. Next, you assign created accounts to appropriate users.

Example: User1 may have access only to the Northwind database, and on this database, User1 may have db_datareader and db_datawriter roles.

_______________

  Nayer Naguib

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.