[nz@dwhtwf01 ~]$ nzsql
Welcome to nzsql, the Netezza SQL interactive terminal.
Type: \h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
SYSTEM(ADMIN)=> CREATE USER sarusso WITH PASSWORD 'please_change_me';
CREATE USER
SYSTEM(ADMIN)=> ALTER GROUP group_dev ADD USER sarusso;
ALTER GROUP
SYSTEM(ADMIN)=> ALTER GROUP group_analyst ADD USER sarusso;
ALTER GROUP
SYSTEM(ADMIN)=> \c NTZ_DWDMP
You are now connected to database NTZ_DWDMP.
NTZ_DWDMP(ADMIN)=> GRANT LIST ON TABLE TO sarusso;
GRANT
NTZ_DWDMP(ADMIN)=> GRANT SELECT ON TABLE TO sarusso;
GRANT
NTZ_DWDMP(ADMIN)=> \c NTZ_DWDMS
You are now connected to database NTZ_DWDMS.
NTZ_DWDMS(ADMIN)=> GRANT LIST ON TABLE TO sarusso;
GRANT
NTZ_DWDMS(ADMIN)=> GRANT SELECT ON TABLE TO sarusso;
GRANT
NTZ_DWDMS(ADMIN)=> \c NTZ_DWSAS
You are now connected to database NTZ_DWSAS.
NTZ_DWSAS(ADMIN)=> GRANT LIST ON TABLE TO sarusso;
GRANT
NTZ_DWSAS(ADMIN)=> GRANT SELECT ON TABLE TO sarusso;
GRANT
NTZ_DWSAS(ADMIN)=> \q
Welcome to nzsql, the Netezza SQL interactive terminal.
Type: \h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
SYSTEM(ADMIN)=> CREATE USER sarusso WITH PASSWORD 'please_change_me';
CREATE USER
SYSTEM(ADMIN)=> ALTER GROUP group_dev ADD USER sarusso;
ALTER GROUP
SYSTEM(ADMIN)=> ALTER GROUP group_analyst ADD USER sarusso;
ALTER GROUP
SYSTEM(ADMIN)=> \c NTZ_DWDMP
You are now connected to database NTZ_DWDMP.
NTZ_DWDMP(ADMIN)=> GRANT LIST ON TABLE TO sarusso;
GRANT
NTZ_DWDMP(ADMIN)=> GRANT SELECT ON TABLE TO sarusso;
GRANT
NTZ_DWDMP(ADMIN)=> \c NTZ_DWDMS
You are now connected to database NTZ_DWDMS.
NTZ_DWDMS(ADMIN)=> GRANT LIST ON TABLE TO sarusso;
GRANT
NTZ_DWDMS(ADMIN)=> GRANT SELECT ON TABLE TO sarusso;
GRANT
NTZ_DWDMS(ADMIN)=> \c NTZ_DWSAS
You are now connected to database NTZ_DWSAS.
NTZ_DWSAS(ADMIN)=> GRANT LIST ON TABLE TO sarusso;
GRANT
NTZ_DWSAS(ADMIN)=> GRANT SELECT ON TABLE TO sarusso;
GRANT
NTZ_DWSAS(ADMIN)=> \q
Nessun commento:
Posta un commento