6 Replies Latest reply on Jul 12, 2009 12:57 PM by EdStevens

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

      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>;


      GRANT ALL TABLE to <username>;


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