InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comSat, 21 Nov 2009 20:48:10 GMT20http://www.teradata.com/teradataforum/Topic15799-22-1.aspxUserRights 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.HTHSun, 28 Jun 2009 06:05:13 GMTjimmhttp://www.teradata.com/teradataforum/Topic15799-22-1.aspxHi,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.ThanksMon, 15 Jun 2009 13:46:03 GMTMDF