Difference Between Create Table and Create Any Table Privileges
I Don't Understand the Difference Between These Two Privileges. I Found These Two Explanations but It's Not Helping Me. Create Table -> Enables a User to...
I don't understand the difference between these two privileges.
I found these two explanations but it's not helping me.
CREATE TABLE -> Enables a user to create a table owned by that user.
CREATE ANY TABLE -> Enables a user to create a table owned by any user in the database.
If a user creates a table it's going to be owned by the user that created it right? I don't get it.
1 Answer
The CREATE TABLE privilege lets you create a table in your own schema. So user scott can do:
create table scott.mytable ( id number );
The CREATE ANY TABLE privilege lets you create a table in any schema in the database. So again, user scott can do:
create table hr.employees ( id number );
That is, make a table that belongs to someone else.
James Sterling reports on renewable energy developments, climate policy, ecological conservation, and green tech innovations around the globe.
