Rights and Users

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

Rights and Users

Rate Topic

Display Mode

Topic Options

Author

Message

Tony

Posted 6/14/2006 10:08:08 AM

Forum Newbie

Group: Forum Members
Last Login: 6/19/2006 5:59:00 AM
Posts: 1, Visits: 1

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

Post #4372

morphik

Posted 6/20/2006 6:51:09 AM

Forum Newbie

Group: Forum Members
Last Login: 6/20/2006 6:51:00 AM
Posts: 4, Visits: 1

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,

morphik

Post #4400

Vinay Bagare

Posted 6/21/2006 8:58:41 AM

Supreme Being

Group: Forum Members
Last Login: 7/5/2009 2:58:22 PM
Posts: 134, Visits: 13

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

Post #4404

Job_Agent

Posted 6/21/2006 9:06:25 PM

Supreme Being

Group: Forum Members
Last Login: 9/8/2009 8:51:09 AM
Posts: 126, Visits: 79

I think use Teradata Administrator tool ,for more ease

Post #4410

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 3 ( 3 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 11:19am