Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 211
  • Last Modified:

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

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
1 Solution
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now