|
|
Re: How to get the tables in Oracle 10g [message #486641 is a reply to message #486627] |
Fri, 17 December 2010 12:00 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/659bbc2efcb1c316d0ff5be84e2b286a?s=64&d=mm&r=g) |
tejokrishna
Messages: 15 Registered: December 2010 Location: Hyderabad
|
Junior Member |
![tejokrishna.y@gmail.com](/forum/theme/orafaq/images/google.png)
|
|
SQL> !
[oracle@localhost dbs]$ sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Dec 17 23:14:35 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> sho user
USER is "SYS"
SQL> grant connect, resource to test;
Grant succeeded.
SQL> conn test/test;
Connected.
SQL> select *from emp;
select *from emp
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> !
[oracle@localhost dbs]$ sqlplus system/manager
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Dec 17 23:16:27 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> grant connect, resource to test;
Grant succeeded.
SQL> conn test/test;
Connected.
SQL> select *from emp;
select *from emp
*
ERROR at line 1:
ORA-00942: table or view does not exist
this is the prob, when i grant the priviliges to test user. its successful. but not getting the tables as test user,
but im getting tables with scott user only; i want tables with test user also. how to get the tables as test.
|
|
|
|
|
|
|
|
|
|
|
|