Archives of the TeradataForum
Message Posted: Mon, 17 Sep 2001 @ 18:14:50 GMT
| Subj: || || Lost use of some PC tools |
| From: || || Tony Howe |
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??