Archives of the TeradataForum
Message Posted: Tue, 11 Sep 2007 @ 16:40:03 GMT
Subj: | | Re: Who has Select Access to Views/Tables |
|
From: | | Fred W Pluebell |
Don't forget that there are multiple ways to grant SELECT access:
GRANT right to user at View / Table level or at Database level (Tablename='All'); see DBC.AllRights
GRANT to pseudo-user PUBLIC at View / Table level or at Database level
GRANT right to ROLE (see DBC.AllRoleRights) and ROLE to User (DBC.RoleMembers). And ROLEs can be "nested" - GRANT to other ROLE but only a
single level (also DBC.RoleMembers).
|