6 Replies Latest reply: Jul 12, 2009 7:57 AM by EdStevens RSS

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

    user559463
      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