You can create a new user, GRANT that new user read-only permissions to the tables you would like them to see. Or, you can create a view of the table and choose any or all the columns you want the users to see.

Eudoro

-----Original Message-----
From: dwightu <oracledba-ezmlmshield-x24223400.[Email address protected]
Sent: Aug 18, 2004 10:48 AM
To: LazyDBA Discussion <[Email address protected]
Subject: Re: subject

The first thing that comes to mind is create a read only table to run the
SQL against then give everbody that right and secure the rest.

Close ??

----- Original Message -----
From: "Hanes Brad W "
<oracledba-ezmlmshield-x13283123.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Wednesday, August 18, 2004 10:18 AM
Subject: subject


> in our test lab, we have non-DBA folks doing database "stuff"...I'd like
to
> know if there is anyway to allow these folks to do their work without
having
> to explicitly give them a password or "powerful" privileges to complete
the
> testing. in other words, is there some way to have a "black envelope"
> schema, table, etc, whose sole purpose is to store usernames and passwords
> to be referenced when non-DBA folks need to run SQL commands to the
> database?
>
> does this make sense? thanks for your help....
>
> Brad Hanes
> SRA International
> 512-460-4129
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html



Oracle LazyDBA home page