learn2222
learn2222

Reputation: 35

does create table privilege give object privileges like select and delete?

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

Answers (1)

Littlefoot
Littlefoot

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

Related Questions