To know roll access

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.

To know roll access

Rate Topic

Display Mode

Topic Options

Author

Message

MDF

Posted 6/15/2009 1:46:03 PM

Forum Newbie

Group: Forum Members
Last Login: 6/15/2009 10:22:38 PM
Posts: 1, Visits: 12

Hi,

I m new to teradata.
I don't have access on DBC. Can anyone tell me, how come i will know which are the database have given me the access in Teradata.

Thanks

MDF

Post #15799

jimm

Posted 6/28/2009 6:05:13 AM

Supreme Being

Group: Forum Members
Last Login: Yesterday @ 3:55:54 AM
Posts: 111, Visits: 263

UserRights will give you all the objects/rights to which you explicitly have access.
UserRoleRights gives you all the objects to which you have access via a role.

So you can just union these views.
A couple of points - rights can be given below database level, so you could have rights to some tables in a database but not others.
2. If your default role is not ALL, you could have rights to an object through a role but may not be able to exercise those rights while working in a different role.

HTH

Post #15937

« Prev Topic | Next Topic »

Reading This Topic

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

No members currently viewing this topic.

All times are GMT -5:00, Time now is 4:45am