Creating an administrative user group

Procedure

1. Connect to the System database as the admin user. For example:
3. [nz@nzhost ~]$ nzsql -d system -u admin -pw password 
4. 
   
5. 
   
6. Create a group for your administrative users. For example:
7. SYSTEM.ADMIN(ADMIN)=> CREATE GROUP administrators;
8. 
   
9. 
   
10. Grant the group all administrative permissions. For example:
11. SYSTEM.ADMIN(ADMIN)=> GRANT ALL ADMIN TO administrators WITH GRANT  OPTION;
12. 
    
13. 
    
14. Grant the group all object permissions. For example:
15. SYSTEM.ADMIN(ADMIN)=> GRANT ALL ON DATABASE, GROUP, SCHEMA, SEQUENCE,SYNONYM, TABLE, EXTERNAL TABLE, FUNCTION, AGGREGATE, USER, VIEW, PROCEDURE, LIBRARY TO administrators WITH GRANT OPTION;
16. 
    
17. 
    
18. Grant the group select permissions on all system and management objects. For example:
19. SYSTEM.ADMIN(ADMIN)=> GRANT LIST, SELECT ON SYSTEM TABLE, SYSTEM VIEW, MANAGEMENT TABLE, MANAGEMENT VIEW TO administrators WITH GRANT OPTION;
20. 
    
21. 
    
22. Add users to the group to grant them the permissions of the group. For example:
23. SYSTEM.ADMIN(ADMIN)=> ALTER USER nzuser WITH IN GROUP administrators;

GRANT LIST,SELECT,DELETE,UPDATE,INSERT,TRUNCATE,GROOM,ALTER,ABORT ON SANDBOX..TABLE TO  SANDBOX_ADMIN;