WITH ADMIN Option
For whatever reason we have the following USER creation statement in our database setup at our customers' sites:
The service contractor of our customer says they don't allow for giving ADMIN option together with CREATE USER and CREATE RESOURCE.
<!-- @page { margin: 2cm } P { margin-bottom: 0.21cm } -->
CREATE USER
SYSADM IDENTIFIED BY <password> ;
GRANT CONNECT, CREATE SESSION,
CREATE VIEW TO SYSADM WITH ADMIN OPTION ;
GRANT CREATE USER, CREATE VIEW, CREATE TRIGGER, CREATE PROCEDURE,
CONNECT,RESOURCE TO VERWALTER IDENTIFIED BY <password> WITH <!-- @page { margin: 2cm } P { margin-bottom: 0.21cm ADMIN OPTION; The naming of SYSADM is only for compatibility reasons with Unify/Gupta/Centura, you name it).The service contractor of our customer says they don't allow for giving ADMIN option together with CREATE USER and CREATE RESOURCE.
0