Give read,wrrite and execute access

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

alalani SSC Enthusiast Points: 183 More actions · Answer 1

USE [MyDB]

GO

EXEC sp_addrolemember N'db_datareader', N'username'

GO

EXEC sp_addrolemember N'db_datawriter', N'username'

GO

Grant Execute to 'username'

GO

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

GRANT Permissions at the schema level or the Object level.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/