OraFAQ Forum: Security » Creating table in other schema

Home » RDBMS Server » Security » Creating table in other schema (oracle 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Creating table in other schema [message #537595]

Thu, 29 December 2011 12:09

rajubuddha
Messages: 1
Registered: December 2011
Location: India

Junior Member

Hi Guys ,

I have a query ,

I need to create a structure DATABASE=>SCHEMA=>TABLE as

DB=>SC=>EMPLOYEE ...but after connecting database i could create table only user my user schema(own schema)only .I want to create a new schema called SC as public and need to create a table . Please help me out...

[EDITED by LF: fixed topic title typo; was "Creatingtableinother schema"]

[Updated on: Thu, 29 December 2011 13:15] by Moderator

Report message to a moderator

Re: Creatingtableinother schema [message #537602 is a reply to message #537595]

Thu, 29 December 2011 12:48

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Create a table in your own schema, and then create a public synonym for this table.

Code: [Select all] [Show/ hide]

SQL> create table test (col number);

Table created.

SQL> insert into test values (123);

1 row created.

SQL> create public synonym test for test;

Synonym created.

SQL> grant select on test to public;

Grant succeeded.

SQL> connect mike/lion
Connected.

Session altered.

SQL> select * from test;

       COL
----------
       123

SQL>

[EDIT: fixed an example]

[Updated on: Thu, 29 December 2011 12:53]

Report message to a moderator

Re: Creatingtableinother schema [message #537606 is a reply to message #537595]

Thu, 29 December 2011 12:58

Michel Cadot
Messages: 68756
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

want to create a new schema called SC as public

There is no such thing than public account.
An account can create a table in another schema only if he has the CREATE ANY TABLE privilege which is a privilege you should not grant.
If you need it then either you are a DBA either there is a flaw in your design.

Regards
Michel

Report message to a moderator

Previous Topic:	Database link password
Next Topic:	Password Expire problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 14 07:20:18 CDT 2025