2447938 - rs_ticket_history permission | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2447938 - rs_ticket_history permission

Symptom

public is granted all permission on rs_ticket_history.

For the reason of security, customer wants to revoke them from public.

If your database "maintenance user" is aliased to dbo, then no issues.

To verify if a maint user is alias to dbo, run the following queries.

    1> select type,user_name(uid),substring(name,1,20) from sysobjects where name = 'rs_ticket_history'
    2> order by type
    3> go

      type
     ---- ----------------------- --------------------
       U     dbo                       rs_ticket_history

   1> sp_helpuser rdb_maint  ---> replace rdb_maint with [dbname]_maint.
   2> go  

    The name supplied is aliased to another user.
    Alias_name ID_in_db Group_name Login_name
    ---------- -------- ---------- ----------
     dbo                1  public     sa

 If you have the same outputs, there is no problem to revoke permission from public on rs_ticket_history.


Read more...

Environment

Replication Server

Replicated databases on ASE

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Replication Server all versions

Keywords

rs_ticket_history  permission ,  "revoke permissions from public" , , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , How To

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.