Friday, November 3, 2017

scrip to get grants and privilege of user in netezza database

Netezza provided script to get grants and privilege of the user.

Syntax:
 nz_my_grants <username> > nz_my_grants_<username>.log

 nz_my_grants Bala > nz_my_grants_Bala.log

This will extract all the  grants and privilege about the user and redirect to log

The  out put log would be like below

\echo
\echo ************************************************************
\echo ************************************************************
\echo ************************************************************
\echo
\echo
\echo '*****  Connecting to database:  "NZ_DB1".'
\echo
\echo
\echo ************************************************************
\echo ************************************************************
\echo ************************************************************
\echo
\connect "NZ_DB1"

/* GRANTs associated with the user Bala */
GRANT  delete, insert, list, update  ON NZ_DB1  TO Bala ;
GRANT  create table  TO Bala ;

/* GRANTs associated with GROUPs that the user Bala is a member of */

No comments:

Post a Comment