You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
SQL> drop user sysdba using plugin Srp;
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-attempted update on read-only database
SQL> drop user foo using plugin Srp;
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-attempted update on read-only database
It will be useful to have ability create/alter/drop users by granting this priviledge to some user (for example, from HR department), but without giving to him any other rights.
Ideally he must be able only to establish connect to some read-only DB.
The text was updated successfully, but these errors were encountered:
Submitted by: @pavel-zotov
Connect as SYSDBA to any read-only database.
Then:
SQL> set list on;
SQL> select mon$read_only from mon$database;
MON$READ_ONLY 1
SQL> select * from sec$users;
SEC$USER_NAME SYSDBA
. . .
SEC$PLUGIN Legacy_UserManager
SEC$USER_NAME SYSDBA
. . .
SEC$PLUGIN Srp
SQL> drop user sysdba using plugin Srp;
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-attempted update on read-only database
SQL> drop user foo using plugin Srp;
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-attempted update on read-only database
It will be useful to have ability create/alter/drop users by granting this priviledge to some user (for example, from HR department), but without giving to him any other rights.
Ideally he must be able only to establish connect to some read-only DB.
The text was updated successfully, but these errors were encountered: