SQL User RSS

• • Reply
  

  pradeep_sing...

  Member

  26 Points

  26 Posts

  SQL User

  Jan 25, 2013 12:38 AM|LINK

  hi guys,
  
  Can I assign one db user to multiple dbs? if yes, how can I do it? 

• • Reply
  

  wmec

  Contributor

  6195 Points

  3214 Posts

  Re: SQL User

  Jan 25, 2013 01:43 AM|LINK

  Check

  http://www.databasejournal.com/features/mssql/article.php/2246271/Managing-Users-Permissions-on-SQL-Server.htm

  Many Thanks & Best Regards,
  HuaMin Chen
  
  • Marked as answer by pradeep_singh on Feb 01, 2013 03:31 AM
• • Reply
  

  pradeep_sing...

  Member

  26 Points

  26 Posts

  Re: SQL User

  Jan 27, 2013 11:45 PM|LINK

  what permission should I grant if I want the user to be able to create trigger?

  thanks

• • Reply
  

  wmec

  Contributor

  6195 Points

  3214 Posts

  Re: SQL User

  Jan 28, 2013 12:48 AM|LINK

  Make sure you have INSERT, UPDATE, or DELETE permissions on the table before creating triggers on that table.

  Many Thanks & Best Regards,
  HuaMin Chen
  
• • Reply
  

  pradeep_sing...

  Member

  26 Points

  26 Posts

  Re: SQL User

  Feb 01, 2013 03:01 AM|LINK

  sorry..

  I mean what db user permission to achieve this?

• • Reply
  

  wmec

  Contributor

  6195 Points

  3214 Posts

  Re: SQL User

  Feb 01, 2013 03:14 AM|LINK

  If you can access the table, you can then try to create triggers on it.

  Many Thanks & Best Regards,
  HuaMin Chen
  
• • Reply
  

  dyyo

  Participant

  1076 Points

  202 Posts

  Re: SQL User

  Feb 01, 2013 03:17 AM|LINK

  you can manually add the user to the database that you want to connect:

  1. Use the SQL Login Manager to create a new MS SQL login in the MS SQL 2008 Manager section of the hosting control panel
  2. Connect to the database using SQL Server Management Studio with your primary login
  3. In Object Explorer, epand the Databases node 
  4. Locate the database to which you want to add the new SQL Login and expand the node
  5. Expand the Security Node
  6. Right click on the Users node and select "New User..."
  7. In the Database User Properties
     • Type the username you want to assign to this login in the "User name" text box
     • Type the login you want to assign to the database in the "Login name" text box
     • In the Database role membership, select the database fixed role you want to grant this login (db_owner fixed database role includes full set of permissions). 
  8. Click OK
  Regards,
  Dyyo - Microsoft Recommended ASP.NET Hosting
  
  • Edited by dyyo on Feb 01, 2013 03:17 AM
  • Edited by dyyo on Feb 01, 2013 03:18 AM
  • Marked as answer by pradeep_singh on Feb 01, 2013 03:32 AM
• • Reply
  

  pradeep_sing...

  Member

  26 Points

  26 Posts

  Re: SQL User

  Feb 01, 2013 03:32 AM|LINK

  thanks guys

  :)