Interestingly enough even though it doesn't seem to give the update
permission it still works, and if you look at the roleprivileges table the
permissions are there. So from a functionality issue - problem solved.
But I am confused as to why I can't see the update permission in
sys.dba_tab_privs, but I can see select, insert, and delete
James
James Coen
06/15/2004 12:55 PM
To: [EMAIL PROTECTED]
cc:
Subject: Problem granting rights to roles
Can someone tell me what I am doing wrong? I am running MaxDB on Win2K, I
am using 7.5.00.14, and I have a small DB with 10 tables, and a couple
users. Things are working quite well, then today I added a new table, and
tried to grant my user roles permission's to this new table using GRANT
<privilege> ON <table> TO <role>. This worked for SELECT, INSERT, and
DELETE; but when I try to give UPDATE permission's it seems to work but no
entries are made in the sys.dba_tab_privs table. Why is that? I even
thought it might be related to the order of adding permission's, so I
revoked all and tried giving SELUPD, and it ignored that command as well.
If I look at the other tables that these users should have UPDATE
permission's for, they have the rights I assigned them. I checked for
errors and found none.
Thoughts?
James Coen
