you can manually add the user to the database that you want to connect:
Use the SQL Login Manager to create a new MS SQL login in the MS SQL 2008 Manager section of the hosting control panel
Connect to the database using SQL Server Management Studio with your primary login
In Object Explorer, epand the Databases node
Locate the database to which you want to add the new SQL Login and expand the node
Expand the Security Node
Right click on the Users node and select "New User..."
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).
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?
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
HuaMin Chen
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
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.
HuaMin Chen
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?
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.
HuaMin Chen
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:
Dyyo - Microsoft Recommended ASP.NET Hosting
pradeep_sing...
Member
26 Points
26 Posts
Re: SQL User
Feb 01, 2013 03:32 AM|LINK
thanks guys
:)