Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Does "GRANT CREATE TABLE TO...." allow deleting and altering tables?

pstein-JavaNetJul 10 2009 — edited Jul 12 2009
When the DBA grants the following to a "default" user:

GRANT CREATE TABLE TO <username>;

does this user have the permission to alter, delete, read tables as well?

If NOT: Is there a full,comprehensive "grant" command which includes ALL possible kind of operations on (his) tables e.g.

GRANT * TABLE to <username>;

or

GRANT ALL TABLE to <username>;

or

GRANT CREATE, INSERT, UPDATE,...?.... TABLE to <username>;

Peter
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 9 2009
Added on Jul 10 2009
6 comments
71,751 views