How to create GRANT permission script – SQL Server

-- Create GRANT script for VIEW
select 'GRANT SELECT ON dbo.' + name + ' TO [user login]' 
from sys.objects where  type  =  'V' order by  name;

-- Create GRANT script for STORED PROCEDURE
select 'GRANT EXECUTE ON dbo.' + name + ' TO [user login]' 
from sys.objects where  type  =  'P' order by  name;

-- Create GRANT script for USER_TABLE
select 'GRANT SELECT, INSERT, UPDATE, DELETE ON dbo.' + name + ' TO [user login]' 
from sys.objects where  type  =  'U' order by  name;

-- Create GRANT script for INTERNAL_TABLE 
select 'GRANT SELECT, INSERT, UPDATE, DELETE ON dbo.' + name + ' TO [user login]' 
from sys.objects where  type  =  'IT' order by  name;

This site uses Akismet to reduce spam. Learn how your comment data is processed.