grant a user execute and select privileges on specific schema to an user in SQL Server

Professionaluser
Posted by Professionaluser under Sql Server category on | Points: 40 | Views : 145
The default schema in SQL server is dbo. Let's assume that Test is user defined schema

Below is the code to grant execute permission/privilege on Test schema

IF EXISTS ( SELECT *
FROM sys.schemas
WHERE name = N'Test' )
GRANT SELECT, EXECUTE ON SCHEMA::Test TO SQLUser1;

Comments or Responses

Login to post response