Wednesday, March 11, 2020

Manage Grants MSSQL objects

How to Manage Grants MSSQL objects?

If you need to Manage grants MSSQL table or any objects you can use following method,

ADD GRANTS

USE [DATABASEUSERGROUP]
GO
GRANT SELECT ON [dbo].[mytable] TO [Domain\username]
Go 

REMOVE GRANTS

USE [DATABASEUSERGROUP]
GO
REVOKE SELECT ON [dbo].[mytable] FROM [Domain\username]
GO

Cheers...
and Most welcome your comments and ideas...