How to grant permissions on database objects
Last modified: October 1, 2024
Permissions on database objects can be granted on the Object Permissions tab of the Security Manager window. To open it, select Security Manager on the Database menu. To give a user some privileges on a database object, perform the following actions.
- Open Security Manager.
- Select a user account in the user account list in the left part of Security Manager, and then switch to the Object Permissions tab.
- Select a database object to grant privileges on in the Objects tree. After selecting an object you will see a list of available privileges.
- Assign the privileges to a user (account) by checking them in the available privileges list.
- Click the Save button on the Security Manager toolbar.
The grid below the Object Permissions tab of the Security Manager contains the current privileges of the user (account). You can revoke a selected privilege by double-clicking it, clicking Revoke Selected Privilege from their shortcut menu, by pressing CTRL+DELETE keys, or by clicking the button next to the list.
To revoke all assigned privileges, select Revoke All Privileges from their shortcut menu, or click the button near the list.
Available privileges for different database objects are listed at the table below:
Database objects | Privileges |
---|---|
Databases | Select, Insert, Update, Delete, Alter, Alter Routine, Create, Create Routine, Create Temporary Tables, Create View, Drop, Event, Execute, Grant Option, Index, Lock Tables, References, Show View, Trigger |
Tables | Select, Insert, Update, Delete, Create, Drop, Grant Option, References, Index, Alter, Create View, Show View, Trigger |
Columns | Select, Insert, Update, References |
Stored procedures and functions | Alter Routine, Execute, Grant Option |
Want to find out more?
Overview
Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.
All features
Get acquainted with the rich features and capabilities of the tool in less than 5 minutes.
Request a demo
If you consider employing this tool for your business, request a demo to see it in action.