EXEC sp_helprotect NULL, NULL, dbo; 或 SQL 复制 EXEC sp_helprotect @grantorname = 'dbo'; 输出报表按权限类别、所有者、对象、被授权者、授权者、保护类型类别、保护类型、操作以及列连续 ID 进行排序。 权限 要求公共 角色具有成员身份。 返回的信息取决于对元数据的访...
sp_helprotect [ [ @name = ] 'object_statement' ] [ , [ @username = ] 'security_account' ] [ , [ @grantorname = ] 'grantor' ] [ , [ @permissionarea = ] 'type' ] 参数[ @name = ] 'object_statement' 当前数据库或语句中具有报告权限的对象的名称。 object_statement 的数据类型为 ...
sp_helprotect[ [ @name = ]N'name'] [ , [ @username = ]N'username'] [ , [ @grantorname = ]N'grantorname'] [ , [ @permissionarea = ]'permissionarea'] [ ; ] Arguments [@name= ] N'name' The name of the object in the current database, or a statement, that's the p...
sp_helprotectno devuelve información acerca de los elementos que pueden protegerse incluidos en SQL Server 2005. Utilicesys.database_permissionsyfn_builtin_permissionsen su lugar. Convenciones de sintaxis de Transact-SQL Sintaxis sp_helprotect [ [ @name = ] 'object_statement' ] [ , [ @usernam...
3. It seems user Test has already had the execute permission on xp_cmdshell. But still got 'permission was denied'. We even captured TTT trace to analyze this issue. Finally, we foundsp_helprotectcan easily find out root cause. There is a 'deny' on public role. ...
sp_helprotect[ [ @name = ]N'name'] [ , [ @username = ]N'username'] [ , [ @grantorname = ]N'grantorname'] [ , [ @permissionarea = ]'permissionarea'] [ ; ] 参数 [ @name = ] N'name' 当前数据库中的对象的名称或语句是报表权限。@name为nvarchar(776),默认值NULL返回所有对象和语...
sp_helprotect[ [ @name = ]N'name'] [ , [ @username = ]N'username'] [ , [ @grantorname = ]N'grantorname'] [ , [ @permissionarea = ]'permissionarea'] [ ; ] Arguments [@name= ] N'name' The name of the object in the current database, or a statement, that's the permissio...
sp_helprotect [ [ @name = ] N'name' ] [ , [ @username = ] N'username' ] [ , [ @grantorname = ] N'grantorname' ] [ , [ @permissionarea = ] 'permissionarea' ] [ ; ] Arguments[ @name = ] N'name'The name of the object in the current database, or a statement, that'...
sp_helprotect[ [ @name = ]N'name'] [ , [ @username = ]N'username'] [ , [ @grantorname = ]N'grantorname'] [ , [ @permissionarea = ]'permissionarea'] [ ; ] Arguments [@name= ] N'name' The name of the object in the current database, or a statement, that's the p...
sp_helprotect [ [ @name = ] 'object_statement' ] [ , [ @username = ] 'security_account' ] [ , [ @grantorname = ] 'grantor' ] [ , [ @permissionarea = ] 'type' ] Аргументы[ @name = ] 'object_statement'Имяобъектавтекущейбазеда...