SAP Knowledge Base Article - Preview

3157522 - The "revoke truncate table on tblname from user" is not working as expected - SAP ASE

Symptom

  1. Login as sa - create a table and revoke truncate from dbo
    isql -Usa -Sase16 -PXXXX -Dpubs2 -w500
    create table abc (a int)
    go
    insert into abc values (1)
    go 5
    revoke truncate table on abc from dbo
    go
    Msg 10393, Level 14, State 1:
    Server 'ase16', Line 1:
    Owner of object 'abc' is denied to execute the command.

    sp_helprotect abc
    go
    grantor       grantee      type    action                    object    column     predicate     grantable
    ---------    ----------  --------    ----------------- ----------- ------------ ------------ --------------
    dbo        All Owners     Deny    Truncate Table   All Tables            All           NULL          FALSE

  2. Login as a user with dbo permissions in the database

    isql -Uuser1 -Psybase -Sase16 -Dpubs2 -w500
    truncate table abc
    go ---truncates the table with no errors


    Read more...

    Environment

    SAP Adaptive Server Enterprise (ASE) 16.0

    Product

    SAP Adaptive Server Enterprise 16.0

    Keywords

    KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error

    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.