Reputation: 35
I use windows 7 and oracle 11g , so when i created user test
and give an him create table privilege
:
grant create table to test;
I notice that this user can also do select,insert,delete
on the table that he created but i don't give him any object privileges.
is create table privilege mean all object privileges are granted?
Upvotes: 1
Views: 86
Reputation: 142713
Table owner can do everything with that table - all DML and DDL actions (selects, inserts, updates, deletes, alters, drops, ... everything).
If you want to let other users do something with your tables, then you'll have to grant those privileges to them.
Upvotes: 2