create new user

[Tarry]

SQL*Plus: Release 8.1.6.0.0 - Production on Thu Nov 7 17:15:37 2002

(c) Copyright 1999 Oracle Corporation.  All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production

appdev@NICK>create user nosey identified by nosey;

User created.

appdev@NICK>grant create session to nosey;

Grant succeeded.

appdev@NICK>@conn nosey/nosey
Input truncated to 15 characters
nosey@NICK>select * from scott.emp;
select * from scott.emp
                    *
ERROR at line 1:
ORA-00942: table or view does not exist
/* well it does he just can't see it! */


nosey@NICK>@conn appdev
Enter password: 
Input truncated to 15 characters
appdev@NICK>grant select any table to nosey;

Grant succeeded.

appdev@NICK>@conn nosey/nosey
Input truncated to 15 characters
nosey@NICK>desc scott.emp
 Name                                                  Null?    Type
 ----------------------------------------------------- -------- ------------------------------------
 EMPNO                                                 NOT NULL NUMBER(4)
 ENAME                                                          VARCHAR2(10)
 JOB                                                            VARCHAR2(9)
 MGR                                                            NUMBER(4)
 HIREDATE                                                       DATE
 SAL                                                            NUMBER(7,2)
 COMM                                                           NUMBER(7,2)
 DEPTNO                                                         NUMBER(2)

nosey@NICK>@conn appdev
Enter password: 
Input truncated to 15 characters


appdev@NICK>drop user nosey;

User dropped.

appdev@NICK>