Error while Granting Access Right

Database
Enthusiast

Error while Granting Access Right

A SP is complied on a Teradata Admin_User.

The Work of the SP is to change the profile of the requested user.

It takes 2 IN parameters: Username whose profile is to be changed and ProfileName value to which it is to be changed.

For changing the profile the Admin_User should have drop profile access on the user.

I am trying to grant the drop profile access right to the Admin_User:

GRANT DROP PROFILE ON PUBLIC TO Admin_User;

Note: I am granting it to PUBLIC so that it is systemwide on all users.

But the above statement is throwing error in TD 14.10.Can somebody tell me what is wrong with the statement?

What is the correct syntax for the same?

Thanks,

Kishore

1 REPLY
Enthusiast

Re: Error while Granting Access Right

Pretty sure DROP PROFILE is a system-level access right. It is used to actually drop profiles from the system. In other words, it does not have an "ON" clause.

GRANT DROP PROFILE TO Admin_User;

Also, I couldn't find it specifically in the documentation, but I do not believe you can specify "ON PUBLIC" for grants.

Note: In Teradata 13.10, you need DROP USER on a user to modify them... I believe this has not changed in TD 14.10. Yes, this means your admin user must have an explicit DROP USER privelege on every user it should be able to modify.