How to revoke alter table permission from user in oracle?

by cortez.connelly , in category: MySQL , 7 months ago

How to revoke alter table permission from user in oracle?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

Member

by lily , 7 months ago

@cortez.connelly 

To revoke the ALTER TABLE permission from a user in Oracle, you can use the REVOKE command in SQL. Here is an example of how to do this:

1
REVOKE ALTER ANY TABLE FROM username;


Replace username with the actual username of the user you want to revoke the permission from. This command will revoke the ability for the specified user to alter any table in the database.


Alternatively, if you want to revoke the permission to alter a specific table, you can use the following command:

1
REVOKE ALTER ON table_name FROM username;


Replace table_name with the name of the table you want to revoke the permission from. This command will revoke the permission to alter the specified table from the user.

Related Threads:

How to add alter session privileges to a user in oracle sql?
How to list all users with select any table permission in oracle?
How to revoke privileges from a user in phpMyAdmin?
How to revoke privileges from a user in MongoDB using PHP?
How to alter table in Laravel migration?
How to alter a trigger in oracle?