Atitit.gui Control and panel ---- Database area-mssql Permissions Configuration Report view members
1. Configure Server Connection Permissions 1
2. Configure Database Permissions 1
3. Set Table / view Security 2
1. Configure Server Connection permissions
Configure Server logins -database-level security-logins-new logins
Role ::p ublic
Author :: Old Wow's paw attilax Ayron. Email:[email protected]
Reprint please indicate source: Http://blog.csdn.net/attilax
2. Configure Database permissions
In the User Mappings tab, for example, as you can see, tick the database you need to set up
User:: Userindb
Schema: dbo (default) ...
Click "Confirm" button. Finished creating the user's action
can also database >>> properties >> permissions set some permissions ... Default only conn permissions.
3. Setting up a table/View Security
In the Testlog database "security"-"TestUser"-"Properties"-"securable"-"Join"-"object type" There are many other object types that can be set at the database level.
Atitit.gui control and Panel----database Area-mssql 2008 Permissions Configuration Report view members