Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Restricting user's resource access
"Tom Best" <oracle_person_at_yahoo.com> wrote in message
news:ah6a3m$2n4$1_at_news.bentley.com...
> Red:
>
> Use the PROFILE keyword of the create/alter user statement:
>
>
>
http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/server.920
> /a96540/statements_84a.htm#2065280
>
> HTH,
> Tom Best
>
And make sure the resource_limit parameter in init.ora has been set to true.
Regards
-- Sybrand Bakker Senior Oracle DBA to reply remove '-verwijderdit' from my e-mail addressReceived on Thu Jul 18 2002 - 15:16:18 CDT