Menu
How to grant the privilege of giving the privilege of creating a session to a user or role in Oracle?
671
To GRANT ALL privileges to a user , allowing that user full control over a specific database , use the following syntax: mysql> GRANT ALL PRIVILEGES ON database_name. * TO 'username'@'localhost';
column list. Use the ALL PRIVILEGES privilege type to grant all of the privileges to the user or role for the specified table. You can also grant one or more table privileges by specifying a privilege-list. Use the DELETE privilege type to grant permission to delete rows from the specified table.
You would use the WITH ADMIN OPTION option in the GRANT statement
GRANT CREATE SESSION TO <<username>> WITH ADMIN OPTION If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
