Home » SQL & PL/SQL » SQL & PL/SQL » Check previlage on a folder/file
Check previlage on a folder/file [message #230927] Fri, 13 April 2007 07:01 Go to next message
sanjitpandey
Messages: 16
Registered: April 2007
Junior Member
Hi,

I tried to check privilege on files using "wwsec_api"
but i got error

PLS-00201: identifier 'WWSEC_API.USER_NAME' must be declared

when i tried to execute the procedure.
Can anybody help me?

Thanks,
Sanjit
Re: Check previlage on a folder/file [message #230932 is a reply to message #230927] Fri, 13 April 2007 07:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You lack some privileges on the object or it does not exist.

Regards
Michel
Re: Check previlage on a folder/file [message #231197 is a reply to message #230932] Sun, 15 April 2007 22:22 Go to previous messageGo to next message
sanjitpandey
Messages: 16
Registered: April 2007
Junior Member
I have to write some files in a folder using PL/SQL procedure. I can write files in the folder i have access to. Now i need to check two things:
1. Does the folder exist or not.
2. Even if the folder exists, do the user have write access to it or not?

Thank you,
Sanjit
Re: Check previlage on a folder/file [message #231206 is a reply to message #231197] Sun, 15 April 2007 23:54 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is a new and different question, create a new thread/topic.

Regards
Michel
Previous Topic: Level pseudocolumn
Next Topic: about SQL*PLUS Enviroment .........
Goto Forum:
  


Current Time: Sun Dec 04 12:42:49 CST 2016

Total time taken to generate the page: 0.17885 seconds