who to create loging user name for database?

• senthilkumar.v

  Mr or Mrs. 500

  Points: 579

  More actions

  August 13, 2008 at 2:48 am

  #77070

  i have create one userlogin name for 'blqdb' database,but this login user name access all databases.i want this user name only allowed particular database only ,it's not allowed another database

• sql_er

  SSCarpal Tunnel

  Points: 4135

  More actions

  August 13, 2008 at 3:27 pm

  #857746

  Go to:

  - Security

  - Logins

  - Database Access

  * Choose the databases you want

  Go to Server Roles and make sure the Server role is not System Administrator