step by step to change the global privilege of user on Netezza database.
SYSTEM(ADMIN)=> \dpu NZ_user1
User object permissions for user 'NZ_user1'
Database Name | Object Name | L S I U D T L A D B L G O E C R X A | D G U T E X Q Y V M I B R C S H F A L P N S
---------------+-------------+-------------------------------------+---------------------------------------------
NZ_DB1 | GLOBAL | | X
GLOBAL | NZ_DB1 | X X X X |
GLOBAL | NZ_DB2 | X |
(3 rows)
Object Privileges
(L)ist (S)elect (I)nsert (U)pdate (D)elete (T)runcate (L)ock
(A)lter (D)rop a(B)ort (L)oad (G)enstats Gr(O)om (E)xecute
Label-A(C)cess Label-(R)estrict Label-E(X)pand Execute-(A)s
Administration Privilege
(D)atabase (G)roup (U)ser (T)able T(E)mp E(X)ternal Se(Q)uence
S(Y)nonym (V)iew (M)aterialized View (I)ndex (B)ackup (R)estore
va(C)uum (S)ystem (H)ardware (F)unction (A)ggregate (L)ibrary
(P)rocedure U(N)fence (S)ecurity
(P)rocedure U(N)fence (S)ecurity
NZ_DB2(ADMIN)=> alter group GROUP_READONLY add user NZ_user1;
ALTER GROUP
SYSTEM(ADMIN)=> \dpu NZ_user1
User object permissions for user 'NZ_user1'
Database Name | Object Name | L S I U D T L A D B L G O E C R X A | D G U T E X Q Y V M I B R C S H F A L P N S
---------------+-------------+-------------------------------------+---------------------------------------------
NZ_DB1 | GLOBAL | | X
GLOBAL | NZ_DB1 | X X X X |
GLOBAL | NZ_DB2 | X |
(3 rows)
Object Privileges
(L)ist (S)elect (I)nsert (U)pdate (D)elete (T)runcate (L)ock
(A)lter (D)rop a(B)ort (L)oad (G)enstats Gr(O)om (E)xecute
Label-A(C)cess Label-(R)estrict Label-E(X)pand Execute-(A)s
Administration Privilege
(D)atabase (G)roup (U)ser (T)able T(E)mp E(X)ternal Se(Q)uence
S(Y)nonym (V)iew (M)aterialized View (I)ndex (B)ackup (R)estore
va(C)uum (S)ystem (H)ardware (F)unction (A)ggregate (L)ibrary
(P)rocedure U(N)fence (S)ecurity
(P)rocedure U(N)fence (S)ecurity
NZ_DB2(ADMIN)=> alter group GROUP_READONLY add user NZ_user1;
ALTER GROUP
Solution:
just need you need to remove the respective global privilege from user and global name on the database will away.
No comments:
Post a Comment