![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Wed, 03 Aug 2011 @ 20:16:05 GMT
Subj: | | Teradata Create object implicit privileges |
|
From: | | Anomy Anom |
<-- Anonymously Posted: Wednesday, August 03, 2011 15:42 -->
Hi,
I have a list of users who has a create table access on XYZ Database, when user creates a Table as a creator, user automatically gets some
implicit privileges on the newly created table in XYZ database. However, I have nearly 50k tables which holds nearly half million records in
Access rights table. I have created a role on XYZ Database with the implicit privileges which user gets, assigned the role to user and then revoke
the all access rights on user. This process looks hideous, Is there any way to restrict users to gain Implicit privileges and gets through
Roles.
Regards
| |