To know the permissions on the procedure.

---To know the permissions on the procedure.
SELECT PERM.[Type],PERM.Permission_name
FROM SYS.DATABASE_PERMISSIONS as PERM JOIN SYS.OBJECTS AS SO
ON PERM.MAJOR_ID=SO.[OBJECT_ID]
WHERE SO.[Name] like 'ProcedureName'

Comments

Popular posts from this blog

System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out

Pre login Handshake or Connection Timeout Period

Transparent Data Encryption(TDE) with Master Key and Certificate in SQL Server