How to revoke alter table permission from user in oracle?

by cortez.connelly , in category: MySQL , a month ago

How to revoke alter table permission from user in oracle?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

Member

by lily , a month 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.