/* CREATE A NEW ROLE */CREATEROLE db_executor/* GRANT EXECUTE TO THE ROLE */GRANTEXECUTETOdb_executor sql 2000实现方法 。。。。拼sql字符串 (1) SELECT'grant exec on' + QUOTENAME(ROUTINE_SCHEMA) + '.' + QUOTENAME(ROU
授與SQL Server 中資料庫使用者、資料庫角色或應用程式角色的權限。 Transact-SQL 語法慣例 語法 syntaxsql 複製 GRANT permission [ ,...n ] ON { [ USER :: database_user ] | [ ROLE :: database_role ] | [ APPLICATION ROLE :: application_role ] } TO <database_principal> [ ,.....
SQL 复制 -- Execute the following as a database owner GRANT EXECUTE ON TestProc TO TesterRole WITH GRANT OPTION; EXEC sp_addrolemember TesterRole, User1; -- Execute the following as User1 -- The following fails because User1 does not have the permission as the User1 GRANT EXECUTE ON ...
以下示例创建一个角色,然后针对EXECUTE数据库中的过程uspGetBillOfMaterials,将AdventureWorks2022权限授予该角色。 SQL CREATEROLEnewrole ;GRANTEXECUTEONdbo.uspGetBillOfMaterialsTOnewrole ; GO G. 授予对列的 UNMASK 权限 以下示例向用户UNMASK授予表中列email的Data.Membership权限(OutreachCoordinator的一部分)。
sql コピー CREATE ROLE newrole ; GRANT EXECUTE ON dbo.uspGetBillOfMaterials TO newrole ; GO G. 列の UNMASK アクセス許可を付与する 次の例では、テーブル UNMASK 内の列 に対する email アクセス許可 (Data.Membershipの一部) をユーザー OutreachCoordinator に付与します。 動的データ ...
授與SQL Server 中資料庫使用者、資料庫角色或應用程式角色的權限。 Transact-SQL 語法慣例 Syntax syntaxsql 複製 GRANT permission [ ,...n ] ON { [ USER :: database_user ] | [ ROLE :: database_role ] | [ APPLICATION ROLE :: application_role ] } TO <databas...
SQL Kopiatu -- Execute the following as a database owner GRANT EXECUTE ON TestProc TO TesterRole WITH GRANT OPTION; EXEC sp_addrolemember TesterRole, User1; -- Execute the following as User1 -- The following fails because User1 does not have the permission as the User1 GRANT EXECUTE ...
B. 授與擴充預存程式的 EXECUTE 許可權 下列範例會對 EXECUTE 授與xp_readmail 的Sylvester1 權限。 SQL 複製 USE master; GO GRANT EXECUTE ON xp_readmail TO Sylvester1; GO 相關內容 sys.system_objects (Transact-SQL) sys.database_permissions (Transact-SQL) REVOKE 系統物件權限 (Transact-SQL) ...
SQL -- Execute the following as a database ownerGRANTEXECUTEONTestProcTOTesterRoleWITHGRANTOPTION; EXEC sp_addrolemember TesterRole, User1;-- Execute the following as User1-- The following fails because User1 does not have the permission as the User1GRANTEXECUTEONTestProcTOUser2;-- The followi...
以下示例创建一个角色,然后针对EXECUTE数据库中的过程uspGetBillOfMaterials,将AdventureWorks2022权限授予该角色。 SQL CREATEROLEnewrole ;GRANTEXECUTEONdbo.uspGetBillOfMaterialsTOnewrole ; GO G. 授予对列的 UNMASK 权限 以下示例向用户UNMASK授予表中列email的Data.Membership权限(OutreachCoordinator的一部分)。