SQL Server - Permissions (GRANT)

Card Puncher Data Processing

Management

Grant

Reference

GRANT CONTROL SERVER TO [LoginName];
GRANT CONNECT TO [LoginName];
GRANT ALTER ON [dbo].[theTable] TO [role] 

View

To view the permissions granted to you on the object, use the fn_my_permissions function like this:

SELECT *
FROM sys.fn_my_permissions('object', 'OBJECT')
;





Discover More
Card Puncher Data Processing
SQL Server - Login

A login can: join a role be authorized to use a database, see Create a Database User. be granted permission The database user is the identity of the login when it is connected to a database. The...
Sql Server Database Security
SQL Server - Role

Roles is a mean to manage permissions in bulk. Assign permissions to roles, and then add and remove users and logins to the roles.



Share this page:
Follow us:
Task Runner