Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Truncate Table using Synonyms

User_3I5YGNov 20 2003

Hi All,

I want to perform a truncate table against SYSADM tables. However, the access profile of all users (except DBAs) is set to another oracle user (SYSAAPPL) which has access to the SYSADM tables through public synonyms. Is it possible to truncate a table through a synonym?. If Yes, Please send your suggestions

Praveen

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 18 2003

Added on Nov 20 2003

#database-security, #database-security-general

0 comments

893 views