Link to home
Start Free TrialLog in
Avatar of myschan
myschan

asked on

Revoke update on public failed

I tried to revoke the update right on public for Tb1 and grant userA this right using both the enterprise manager and isql "revoke update on Tb1 from public' and received no error msg. But when i use the enterprise manager or the sp_helprotect to view Tb1, the right is available to all users and public.  Why is it so?
Avatar of myschan
myschan

ASKER

Edited text of question
Are you looking at the table or the rights to the table ?
Avatar of myschan

ASKER

I think I am looking at the rights to the table:  The 'sp_helprotect Tb1' actually returned a list of 39 rows of Select/updat/... rights to each users including public.
Have you run DBCC CheckDB lately?
Seen that once before. There was a duplicated record in sysprotects. Revoke or enterprise manager did no help. Don't know how it happened...

We had  to allow direct updates against system tables and then manually delete the faulty row.
This is tricky because system tables are well normalized and you have to deal with 'ids' coming from several different tables... (need many joins or a good memory :)
Hope this helps.
ASKER CERTIFIED SOLUTION
Avatar of Jim_SQL
Jim_SQL

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial