Archives of the TeradataForum

Message Posted: Wed, 11 Jun 2014 @ 12:07:45 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

Whenever an object is dropped the rights on that object will be dropped from access rights table.

May be you can restore DBC.Accessrights table from last nights backup into a temporary database (For ex: DBA_DATA.AccessRights_new).

Create a new view as like DBC.Allrights (replace DBC.AccessRights table in the view with your new table DBA_DATA.Accessrights_new) and check which all access rights were existing on that object to users.

Similarly, check DBC.allrolerights.

I haven't tied, but, hope this works.

Thanks,

Sravan.

SRAVAN KUMAR BODLA
GCC International - Technical Consultant

	<Prev	Next>		<<First	<Prev	Next>	Last>>