Message-ID: <00b101c14c05$1b647380$e18a0ad2@dual466c> From: "Andrew McGlashan" <aem@bigpond.com> Date: Wed, 3 Oct 2001 22:15:34 +1000 Subject: Re: [suse-oracle] dbastudio: problem to create tables
Each Oracle user is a "schema" in itself. For other users to 'see' and
'operate' on table / objects owned by one shema, you must grant access to
the other users, either directly or via a common role that you can create.
You can make public grants which gives all schemas (users), access to the
object.
An example
$ sqlplus scott/tiger
sql> create table xtable (xcolumn varchar2(10);
sql> grant all on xtable to public;
sql> connect adam/adam
sql> insert into scott.xtable values ('test data');
sql> commit;
sql> select count(*) from scott.xtable;
COUNT(*)
-------------
1
sql> create synonym ytable for scott.xtable;
sql> select * from y;
xcolumn
----------
test data
sql> exit
$
----quick sample with a role....
$sqlplus system/manager
sql> create role combo;
sql> grant combo to adam/adam;
sql> conn scott/tiger
sql> grant all on xtable to combo;
sql> conn adam/adam
sql> desc scott.xtable
...output here...
sql> exit
$
Regards
Andrew McGlashan
04 2574 1827
----- Original Message -----
From: "Javier Ferruz Rodriguez" <fefe@dei.inf.uc3m.es>
To: <suse-oracle@suse.com>
Sent: Wednesday, 3 October 2001 12:27 AM
Subject: [suse-oracle] dbastudio: problem to create tables
>
> I use suse 7.0, Oracle8iR3 (8.1.7) and dbastudi 2.2.0
>
> When I'm going to create a new table in combo "Scheme"
> are "users" (adam, blake, clark, ctxsys, ...., scot,
> sys, system and tracesvr) and aren't "schemes" (ctxsys,
> dbsnmp, mdsys, ordplugins, ordsys, outln, public, sys
> and system).
>
> Can anyone help me?
>
> Thanks in advance,
>
> --
> To unsubscribe, e-mail: suse-oracle-unsubscribe@suse.com
> For additional commands, e-mail: suse-oracle-help@suse.com
>
>
This archive was generated by hypermail 2.1.0 : Thu Oct 11 2001 - 14:55:26 PDT