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 , SAP Business Suite on Sybase ASE Database Platform , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.