Thursday, November 2, 2017

step by step to change the global privilege on Netezza database

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


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