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, as shown in, tick the database you want to set up
User:: Userindb
Schema: dbo (default) ...
Click "Confirm" button to complete the action of creating the user
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 object"-"Add"-"Object type" Here are some more object types that can be set at the database level.
Atitit.gui control and Panel----database Area-mssql 2008 Permissions Configuration Report view members