Access Control
Date: 2 Nov 2002 06:40:42 -0800
Message-ID: <c22bb40d.0211020640.394223de_at_posting.google.com>
I am an Open University student in Hong Kong studying relational database.
The course material told me that if user A created a table and want user B to be able to delete and update it, user A need to grant delete and update privileges. So I did the necessary work and try the real test.
When I try to delete or update as user B, I get SQLSTATE = 42000 error telling me that user B "do not have permission to select from" that table. Only after user A grant select privileges to user B as well, then user B can delete and update the table created by user A.
As usual, tutors and course coordinator do not anwer this question, neither did they answer most of the other questions posted by my classmates.
We are using SQL Anywhere as our course software. Is this software non-standard that cause this problem or is my course material wrong and we need to grant select privileges also for delete and update?
Regards,