CREATE USER device42 IDENTIFIED BY "&1"
PROFILE pwd_noexpire
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE temp;
Â
GRANT CREATE SESSION TO device42;
GRANT SELECT ON V$SESSION TO device42;
GRANT SELECT ON DBA_SEGMENTS TO device42;
GRANT SELECT ON DBA_OBJECTS TO device42;
GRANT SELECT ON SYS.ALL_USERS TO device42;
GRANT SELECT ON DATABASE_COMPATIBLE_LEVEL TO device42;
GRANT SELECT ON SYS.PRODUCT_COMPONENT_VERSION TO device42;
TODO
TODO