Atitit.gui control and Panel----database Area-mssql 2008 Permissions Configuration Report view members

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