Symptom
Permission of a object was granted to public by a user, but this user does not exist in the database now.
The permission can not be revoked by running revoke command
The output of sp_helprotect shows a NUll value on grantor column, for example:
1> sp_helprotect test_tab
2> go
grantor grantee type action object column predicate grantable
------- ------------------- ------ ------ ------------- ------ --------- ---------
NULL public Grant Delete test_tab All NULL FALSE
The value of column grantor does not exist in the system table sysusers
1> select uid,name from sysusers where uid in (select grantor from sysprotects where id=object_id("test_tab"))
2> go
uid name
----------- ------------------------------------------------------------
(0 rows affected)
Read more...
Environment
-
Adaptive Server Enterprise (ASE) 15.x
-
Adaptive Server Enterprise (ASE) 16.x
Product
Keywords
sp_helprotect, grantor, revoke, ASE, sysprotects , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.