All Forums Database
Lizarb 2 posts Joined 12/11
01 Apr 2014
Create a user with a role to GRANT only privileges

Hi everyone!
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.

You must sign in to leave a comment.