Tuesday, June 3, 2014

Netezza Admin / DBA role privileges

In Netezza, there is a default admin user which you can use.  But how about creating a second admin user?  You can assigned the permissions below.

create group DBA_GROUP;

-- Object permission
grant all on USER to DBA_GROUP;
grant all on MANAGEMENT VIEW to DBA_GROUP;
grant all on MANAGEMENT table to DBA_GROUP;
grant all on SYSTEM VIEW to DBA_GROUP;
grant all on SYSTEM TABLE to DBA_GROUP;
grant all on PROCEDURE to DBA_GROUP;
grant all on LIBRARY to DBA_GROUP;
grant all on AGGREGATE to DBA_GROUP;
grant all on FUNCTION to DBA_GROUP;
grant all on SYNONYM to DBA_GROUP;
grant all on SEQUENCE to DBA_GROUP;
grant all on EXTERNAL TABLE to DBA_GROUP;
grant all on DATABASE to DBA_GROUP;
grant all on GROUP to DBA_GROUP;
grant all on TABLE,VIEW to DBA_GROUP;

-- Admin permission
grant ALL ADMIN to DBA_GROUP;

create user NZADMIN with password 'abc123';

alter group DBA_GROUP add user NZADMIN;

create group DBA_GRA_GROUP with resource minimum 50 resource maximum 100;

alter user NZADMIN in resourcegroup DBA_GRA_GROUP;

No comments:

Post a Comment