Archives of the TeradataForum

Message Posted: Mon, 17 Sep 2001 @ 18:14:50 GMT

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

Here's my situation. I have a database where all my Views/Macros for all tables are stored (database=VMDB) We used to allow SELECT access to all views/macors in this database. (GRANT SELECT ON VMDB TO PUBLIC) This turned out to be the wrong thing to do. So now we GRANT SELECT ON VMDB.view/macro_name TO userid; But in doing this, there "PC Tools" have stopped working, the point and click stuff, it say they do not have SELECT access to VMDB. Queryman is one of them along with MS Access, SAS Query etc.

How can I GRANT where they can still use there tools but only have access to the views/macro's they are allowed??

Thanks, Tony.

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