February 8, 2010 at 11:05 am
how to create sql users for the security in the server instance .could u pls give me the scenario for creating users and permission rights for the db users.
February 10, 2010 at 4:14 pm
SSMS --> Security --> Right click on Login --> from there you can do it.
EnjoY!
February 10, 2010 at 5:31 pm
ravilella_24 (2/8/2010)
how to create sql users for the security in the server instance .could u pls give me the scenario for creating users and permission rights for the db users.
What do you mean by scenario for creating users and permission rights?
As you have different users and applications you need them to access SQL Server (which cannot use AD accounts) so you need SQL Logins and Permissions (security) does not need any introduction..
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
February 10, 2010 at 8:45 pm
If you are trying provide / create access to the users on SQL the you have to create LOGIN and map the users to the databases.
Create login > User Mappings > select a database > give permissions required.
Hope this adds.
- Win
Cheers,
- Win.
" Have a great day "
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply