Know what rights/permission granted in a database

Professionaluser
Posted by Professionaluser under Sql Server category on | Points: 40 | Views : 168
sp_helprotect Returns a report that has information about user permissions for an object, or statement permissions, in the current database.

Syntax of sp_helpprotect is as follows:
sp_helprotect [ [ @name = ] 'object_statement' ] 
[ , [ @username = ] 'security_account' ]
[ , [ @grantorname = ] 'grantor' ]
[ , [ @permissionarea = ] 'type' ]

Comments or Responses

Login to post response