T-SQL How to grant role to user with ADMIN/GRANT option in SQL Server 2008
After creating roles and granting privileges to them, I want to grant the privileges of a specified role to a user with grant option so that the user can grant privileges to others, how to do with it? GRANT INSERT ON someTable TO rolem_has_some_permissions WITH GRANT OPTION GO EXEC sp_addrolemember 'rolem_has_some_permissions', 'sabertazimi' GO Doing like this can't make 'sabertazimi' to grant his privileges to others.
The stored procedure sp_addrolemember has 2(two) parameters only: sp_addrolemember [ #rolename = ] 'role', [ #membername = ] 'security_account' WITH GRANT OPTION has nothing to do with sp_addrolemember, instead it is the option of GRANT. edited: If you want your role members to be able to grant their permissions to others, you should grant these permissions to the role with the grant option. When the user has to grant a permission to some other user, he must use the additional AS clause like this: grant select on myTbl to AnotherUser as MyRole
Select joining table based on condition
Linked server with same server name
How to group by two dates to sum an quantity
Retrieving record to a combo box in vb.net
Need select 2 rows from Table2, which is joined with Table1. See description
Can't add a connection in Visual Studio: no server name available
Average of a date column in sql [duplicate]
How to get the previous row value with an ORDERING BY DATE?
How to disable/enable full text indexed in SQL Server using dynamic SQL?
Generate DDL (Create) in SSIS from an Input Source
SQL Server Foreign Keys across multiple table levels
Delete some symbols from Sql Server
error of loading geometry data from csv file to Spatialite
TSQL: how to eliminate join on Null values when Column value is available
Create multiple foreign keys referes to the same table in EF code first
Suppress header output of T-SQL query