Re: Creating a 'helpdesk' user

In article <902027f8.0108171107.4a337462_at_posting.google.com>, fornewsgroups_at_vikas.mailshell.com (Vikas Agnihotri) wrote:
>jeff_at_work.com (Jeff) wrote in message
> news:<9ljbik$o9t$1_at_cronkite.cc.uga.edu>...
>
>> 1. How about granting the CREATE TABLE WITH ADMIN OPTION, but restrict
>> hepdesk's user quotas to 0, disallowing them the space to actually create
>> objects in a tablespace? (more below)
>
>Yes, thats an idea. Or I could set helpdek's default tablespace to a
>TEMPORARY tablespace so that they cant create any permanent objects
>there.

But does that prevent them from designating the tablespace to create objects in?

>> One other possibility might be to create a stored procedure that (using your
>> rights and the DBMS_SQL package) grants the rights and roles you need.
>> If that would work, you could simply grant execute rights on the one
> procedure to helpdesk without granting them any additional rights. If this
> is possible,
>> please post back because I'd like to know too.
>
>Yes, this is possible. A lot of work, but possible.

Well, it'd be a lot of work upfront, but you might save yourself some time down the road if you ever have to rebuild the helpdesk user. Besides, what else do DBA's have to do all day?? ;-) Received on Mon Aug 20 2001 - 07:34:15 CDT