Categories:: System Functions (Control)

CLEANUP_DATABASE_ROLE_GRANTS¶

Revokes privileges on dropped objects from the share and grants the database role to the share.

Syntax¶

CLEANUP_DATABASE_ROLE_GRANTS( '<database_role_name>' , '<share_name>' )

Copy

Arguments¶

'database_role_name'

The name of the database role.

If the identifier is not fully qualified in the form of db_name.database_role_name, the command uses the database role in the current database for the session.

'share_name'

The name of the share.

Access control requirements¶

To call this function, the active role must have the global MANAGE GRANTS privilege.

Usage Notes¶

None.

Example¶

Call the function:

SELECT CLEANUP_DATABASE_ROLE_GRANTS('mydb.dbr1' , 'myshare');

Copy