Tag Info

New answers tagged

0

An issue I found on a similar problem was that the ‘first’ grant on the object had to be done ‘with grant option’. Eg for the issue above, this would therefore mean: GRANT SELECT ON <underlying table owner>.<table_name> TO CST0 WITH GRANT OPTION; Then running GRANT SELECT ON <schema>.<view_name> TO CST0; should work. Note this ...


3

If a system privilege is granted with ADMIN OPTION to a user, this user can grant this system privileges to other users, e.g. after GRANT CREATE SESSION TO SCOTT WITH ADMIN OPTION Scott is able to grant CREATE TABLE to other users. He is also able to grant CREATE TABLE to other users WITH GRANT OPTION. WITH GRANT OPTION works for roles too. An object ...


1

In the SQL Language Reference you will find under Prerequesites (emphasized by me): The owner of the schema containing the view must have the privileges necessary to either select (READ or SELECT privilege), insert, update, or delete rows from all the tables or views on which the view is based. The owner must be granted these privileges directly, rather ...


0

Login as SYSDBA and you need to do GRANT ALL PRIVILEGES TO USER to the newly created user. SQL> show user USER is "SYS" SQL> create user test_all_privs identified by test_all_privs; User created. SQL> GRANT ALL PRIVILEGES TO test_all_privs; Grant succeeded. SQL> conn test_all_privs@pdborcl Enter password: Connected. SQL> select count(*) ...


1

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


0

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



Top 50 recent answers are included