IBM Data Management Community Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems. Join / Log in
Does Netezza have a way to GRANT permissions on objects given a set prefix?Something like "GRANT ALL ON 'ABC_%'.* TO GROUPABC" as a way to say they can do anything to tables in the database that start with "ABC_"Appreciate any advice, thank you!
>> GRANT CREATE TABLE TO that_user;
This makes sense, thank you! That will help them create their own tables in the same environment as the tables they'd like to CTAS source or import their own data. Then, it would be a training task to ask them to create all of their tables as "ABC_", for example, if I want them to stay in that prefix. Also tested to make sure after CREATE, they're able to TRUNCATE, DELETE, INSERT, DROP - and they will. Main concern was ensuring they could do no harm to other existing objects. Will give this a try - we have backups :) thank you!