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 */
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