Thursday, 25 October 2012

Where is the GRANT table option usually done? When tables are newly created, what is the default role and what the default privileges which get assigned?

The GRANT option for any particular table depends on the privileges of the user. If it is an admin user you can grant privileges at any point of time.
The default roles associated with the newly created tables depend on he schema in which they are created.

No comments: