Printable View
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?
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.