Archives of the TeradataForum

Message Posted: Mon, 01 Sep 2014 @ 12:42:57 GMT

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

Hi Vamsi,

If I've understood your requirement correctly, you can't.

Assume a user has SELECT on db1.

If you want to prevent them from selecting from db1.t1 you cannot do it using access rights.

You either have to move t1 to another database, or revoke the database level access right and then grant at the object level for all other objects in database db1.

You may be able to achieve this using row level security (I don't know), but that is "a whole different ball game".

If I've misunderstood then can you please give an example of what you are trying to do.

Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)

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