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