2772063 - How to revoke the permission from public when the grantor of this permission does not exist in current database

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)

• Adaptive Server Enterprise (ASE) 15.x
• Adaptive Server Enterprise (ASE) 16.x

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