Mega Code Archive

 

Categories / MSSQL Tutorial / User Role

 

Managing Application Roles

CREATE APPLICATION ROLE DataWareHouseApp WITH PASSWORD = 'YourPass', DEFAULT_SCHEMA = dbo -- Now grant this application role permissions GRANT SELECT ON YourTable1 TO DataWareHouseApp EXEC sp_setapprole 'DataWareHouseApp', -- App role name 'YourPass' -- Password -- Works SELECT COUNT(*) FROM YourTable1 ALTER APPLICATION ROLE DataWareHouseApp WITH NAME = DW_App, PASSWORD = 'YourPass2' DROP APPLICATION ROLE DW_App