SAP Knowledge Base Article - Preview

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

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

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

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.