Re: Newbie: Simple User question

bbreukelen_at_gmail.com wrote in
news:1122374256.385501.320080_at_g43g2000cwa.googlegroups.com:

> 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.

In cases like this I write SQL which generates SQL like:

SPOOL MYNEW.SQL
SELECT 'GRANT SELECT ON ' || TABLE_NAME || ' TO WEBSERVER;' FROM USER_TABLES;
SPOOL OFF
@MYNEW.SQL Received on Tue Jul 26 2005 - 08:21:07 CDT