|
|
|
|
| Re: user and metadata permissions [message #444118 is a reply to message #444117] |
Thu, 18 February 2010 14:28   |
miroconnect@yahoo.com
Messages: 202
Registered: April 2006
|
Senior Member |
|
|
ok I am getting connection using a non schema user in java,
and would like to call a sql function, for calling a function I must know what are the parameters , to know the parameters I must get metadata from connection,now this metadata does not return any information , I would like to know why the connection is not returning metadata for this user , now If I get connection using schema user I get metadata information , please help me see metadata inforamtion for any user
|
|
|
|
|
|
| Re: user and metadata permissions [message #444137 is a reply to message #444121] |
Thu, 18 February 2010 16:59 |
miroconnect@yahoo.com
Messages: 202
Registered: April 2006
|
Senior Member |
|
|
here in other words
I get connection for a non schema user and try to call a sql function
the generated call is
DEBUG org.springframework.jdbc.core.JdbcTemplate - Calling stored procedure [{? = call SSI_INTEGRATION.GETUSERINFO()}]
now If I get connection for a schema user the generated call is
org.springframework.jdbc.core.simple.SimpleJdbcCal l - Compiled stored procedure. Call string is [{? = call SSI_INTEGRATION.GETUSERINFO(?)}]
see the difference the first call connection object could not tell that this function needs an input parameter ,
but the second a schema user it said ab out the input paramter
, now I am trying to find what might cause this difference?
in oracle terms can I find if user has persmission to parameters of a fucntion ?
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
