Tag Info

New answers tagged


If I am not mistaken, the test Database is created by default. In addition, the mysql.db table contains rows that permit all accounts to access the test database and other databases with names that start with test_. This is true even for accounts that otherwise have no special privileges such as the default anonymous accounts. This is convenient for ...


The PostgreSQL 9.3 Documentation has outlined how to alter default permissions. Follow this link to learn more! Here is an excerpt that demonstrates how one would change the default permissions for a GROUP: ALTER DEFAULT PRIVILEGES [ FOR { ROLE | USER } target_role [, ...] ] [ IN SCHEMA schema_name [, ...] ] abbreviated_grant_or_revoke ...


You can use the system catalog views. Generally speaking any view SYSCAT.xxxxxAUTH will show the authorizations for that particular area. Examples include SYSCAT.DBAUTH is authorizations at the database level. SYSCAT.ROLEAUTH is authorizations to roles. SYSCAT.INDEXAUTH is authorizations for indexes, etc.


Under 9.7, whichever ID creates the database is automatically granted DBADM WITH DATAACCESS WITH ACCESSCTRL and SECADM. So you should be able to log in to the databases with that ID to perform the grants you need. If this came from another environment, you may have to create the ID locally in order to get into the database. Only an ID with SECADM can grant ...

Top 50 recent answers are included