RE: user account setup

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Mon, 21 Jun 2004 16:03:02 -0400
Message-ID: <4C9B6FDA0B06FE4DAF5918BBF0AD82CF03B455DB@bosmail00.bos.il.pqe>

Alter session set current_schema =3D scott;

Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
"Post Hoc Ergo Propter Hoc"

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Nguyen, David M Sent: Monday, June 21, 2004 4:00 PM
To: oracle-l_at_freelists.org
Subject: user account setup

I create an user account and grant "select any table" for someone to query database tables that belongs to SCOTT schema. In order to describe table structure that belongs to SCOTT he has to type.
=20

SQL> describe SCOTT.tablename;

=20

He asks me is there a way to query SCOTT object without typing "SCOTT." in front of table name?

=20

Also, how do I create an account and grant all SCOTT's privileges to him? I want his account exactly to be the same as SCOTT.

=20

Thanks,
David

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon Jun 21 2004 - 15:00:13 CDT