-
granting to a trigger
i'm already granting privilege to a user to create triggerin our database. But when we run the trigger, we got error : table or view does nt exists.
Before this, we also grant select, insert, update, delete to that user.
Plz anybody help me. urgent.
-
hi
Hi
include tableowner.tablename
ex.
select * from tableowner.tablename;
Thomas
-
its trigger it brings up to date another table? if yes, you also need Grant for the other table.
Márcio de Souza Almeida
DBA Oracle / SQLServer / PostgreSQL
Rua Cupa, 139 Apto 85 A
Penha - São Paulo - SP
03640-000 - Brasil
http://www.directory.com.br
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|