Symptom
- 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 - 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.