Description
Permissions describes the policies and the guidelines for administering the categories of avenue that govern the standard principals that need to be securables. Grant and Revoke are the permission used in SQL Server and at the same time the user can deny the permissions to the SQL Server.
Description
Microsoft SQL Server consists of some of the key applications that provides some of the pictorial sessions such as:
- Top scalability issues with SQL Server 2012
- Postponing the scaling decision
- Application architecture and design issues
- Database architecture and design issues
- Indexing strategy and maintenance
Description
Following are the steps that describes the functional procedures for accessing the permissions.
Step - 1
Open SQL Server Management Studio(SSMS) tool.
Step - 2
Select Server name and click on Connect button.
Step - 3
Then it will display the object explorer with the SQL Server details.
Step - 4
Expand Splessons-2\SQL2012(SQL SERVER 1) it will displays some of the standard object explorers.
Step - 5
Expand Security.
Step - 6
In secutities, double click on Splessons-2\kalyan.varkala.
Step - 7
It will display the Login Properties.
Step - 8
In the login properties select Securables and check the box where the permission need to be granted and click on OK button.
Description
By using this permission concepts, the SQL Server Administrator will grant all the privileges for each and every user or client. And by following the above steps the user can able to create a database ,drop a database, alter all the specification in deeds in the SQL Server database.
Key Points
- Permissions - Grant and Revoke are the permissions that are used in SQL Server database for accessing the specific indeeds of a particular user.