Re: Newbie: Simple User question

First of all thank you all for the responses.

The reason I want the new user too access the tablespace is security. I don't want to use the originat user because a have to embed the username/password into the PHP code and other people are able to see the code that are not allowed to enter the oracle dbase. The Remedy dbase user has far to many privaliges to be out on the street.

I wanted to restrict the user to the dbase only coming from localhost so people cannot use the account to connect to the dbase from remote computers but this is not very important if the restrictions are ok.

I already created a user with the role connect and I found out that I can give the user permissions using eg. -GRANT SELECT ON
"ARADMIN"."ARSCHEMA" TO "Webserver"-

But I'd like to use something like -GRANT SELECT ON "ARADMIN"."%" TO
"Webserver"- but this doesn't work.

About the last part, I'm not lazy. It's just that I looked up a lot of responses on similar questions and the answer always is 'Pickup a book and learn all about the oracle'.

I can understand that but the project does not allow me to and this is the only thing I need to setup. The rest will simply be handled by the Remedy application so I feel like it's a waste of time for me.

I can imagine that some of you don't want to answer my question because of this reason. That's not a problem at all. Just don't waste you time by giving a response without an answer.

Thanks again,

Boudewijn van Breukelen Received on Tue Jul 26 2005 - 05:37:36 CDT