Rights and Users

Tools & Utilities

Rights and Users

Hi!

I would like to know how to list all the users and their rights (with sql assistant for example) when you are connected to a data source. Is there any query which is able to get all the roles (groups), their rights and theirs users ?

Regards,

/Tony
3 REPLIES

Re: Rights and Users

Hi!

If you want to collect information about all users and their rights, you can simply use DBC.UserRights view.

To get an answer to your second question, try to join other two DBC views: RoleMembers and UserRoleRights.

Regards,
Enthusiast

Re: Rights and Users

If you are DBA, you can query DBC.Users (or DBC.Databases where dbkind = 'U')

You may also want to use DBC.AllRoleRights instead of DBC.UserRoleRights.

If the grants are direct (w/out using roles), you can query DBC.AllRights.

Vinay
Kks
Enthusiast

Re: Rights and Users

I think use Teradata Administrator tool ,for more ease