-- 查询存储过程的权限SELECT*FROMfn_my_permissions('MyStoredProcedure','OBJECT')WHEREgrantee_principal_id=USER_ID('[testUser]');-- 检查 testUser 在 MyStoredProcedure 上的权限 1. 2. 3. 4. SELECT * FROM fn_my_permissions('MyStoredProcedure', 'OBJECT') WHERE grantee_principal_id = USER_...
a stored procedure can call other stored procedures, or a stored procedure can access multiple tables. If all objects in the chain of execution have the same owner, then SQL Server only checks the EXECUTE permission for the caller, not the caller's permissions o...
Stored procedures Overview Create Modify Delete Execute Specify parameters Grant permissions Parameters Properties Return data Recompile Rename View definition View dependencies OLE automation objects in T-SQL Tables Track changes Triggers User-defined functions ...
Access can require multiple permissions, as in the following examples: A stored procedure can require both EXECUTE permission on the stored procedure and INSERT permission on several tables that are referenced by the stored procedure. A dynamic management view can require both VIEW SERVER STATE and ...
SQL Server提供了一系列的系统视图,可以用来查询数据库对象的权限信息。我们可以使用sys.database_permissions、sys.objects等视图来查看存储过程的权限。 以下是一个简单的示例代码,展示如何获取存储过程的执行和查看定义权限: SELECTo.nameASStoredProcedureName,pr.type_descASPermissionType,pr.state_descASPermissionStat...
Please start any new threads on our new site at . We've got lots of great SQL Server experts to answer whatever question you can come up with. All Forums SQL Server 2000 Forums SQL Server Administration (2000) drop table permissions through stored procedure...
Learn how to create a Transact-SQL stored procedure by using SQL Server Management Studio and by using the Transact-SQL CREATE PROCEDURE statement.
This article describes how to create a SQL Server stored procedure by using SQL Server Management Studio and by using the Transact-SQL CREATE PROCEDURE statement.PermissionsRequires CREATE PROCEDURE permission in the database and ALTER permission on the schema in which the procedure is being created....
Access can require multiple permissions, as in the following examples: A stored procedure can require both EXECUTE permission on the stored procedure and INSERT permission on several tables that are referenced by the stored procedure. A dynamic management view can require both VIEW SERVER STATE and ...
It is not an easy process. There are several articles that have been written about this as well as third-party tools you can find to decrypt objects. So it is not a 100% secure method, but it takes effort to decrypt objects as well as having the right permissions. ...