-
Hi,
Are there any restrictions on creating a db procedure using a synonym for a table which is present in the other user?
I am getting an error,
8/1 PL/SQL: SQL Statement ignored
8/55 PLS-00201: identifier 'STRK2.USER_AGENT' must be declared
where strk2.user_agent is a table(name user_agent) in user strk2, for which the synonym is user_agent
can you help
Badrinath
-
You don't have privileges on that table. That is why you are getting that error. Check the privileges.
-
I have all the privilages, I am able to select from this tables, but I am not able to create a view or create a procedure based on this table on the other schema(strk2)
badrinath
-
Do you get the privileges from a role or are they directly granted to you?
Jeff Hunter
-
I GET IT FROM ROLE.
WHAT DIFF DOES IT MAKE TO GET IT FROM ROLE OR DIRECTLY
Pl explain
Badrinath
-
How different is it that grants given through role compared to direct grant
Badrinath
-
privileges granted through a role are not visible from stored procedures, functions, packages, etc.
if they are granted directly then they are visible from them.
It's a silly rule that Oracle has given us (IMHO), but we have to live with it.
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
|