Create a user with a role to GRANT only privileges
I'm new at this forum and I'd like to share a need I have in the company I work.
We are going to migrate our DB2 environment to Teradata, but we have a separated security area where they only grant privileges to users, but they can't create any kind of objects.
So, is there a way to create an specific role where only GRANT privilege is given to SECADMIN, for example? Our DBAs shouldn't have permission to grant privileges on user objects. But, our main concern would be to create a user that owns only a security profile to give permission on objects to users and nothing else.