Useful Netezza Commands

​

GRANT ALL on Table TO testuser;

  

ALTER DATABASE MPDPD01 SET DEFAULT SCHEMA testschema

select database, defschema from _v_database where database='TESTDB'​