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


    truncate table, revoke truncate table, permissions, granular permissions, CR 826254, table truncate error, master database permissions, dbo user permissions, permission denied truncate table, database object permissions, database security , 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.