473,322 Members | 1,522 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

schema in oracle

kindly help me to know about schema in oracle 9i
Mar 29 '07 #1
3 2446
hi,
the schema is an object where all table,procedures,function are stored,to see
all schema connect via sys and write select * from all_users,this will show all the schema in the database.
kindly help me to know about schema in oracle 9i
Apr 30 '07 #2
chandu031
78 Expert
Hi,

Unlike in other databases, a schema in oracle is equivalent to a user. So if you create a user , then Oracle automatically creates a schema for the user. When a user logs into oracle, all the tables, procedures, functions , views etc.. that he creates or modifies will be belonging to his schema(unless he has those privileges to other's schemas). A schema is not a place where the database objects are stored. It is rather a reference to a user with his specified privileges and grants on the database.

I had a tough time with this concept as I was working on DB2 earlier and was able to create multiple schemas for a user. When I started porting the application to Oracle, I came across this problem(well it was a problem to me) of Schema = user . I really wanted to have more than one schema for a user with different set of privileges for each of them. But I ended up creating multiple users instead.

Does anyone has any opinions or suggestions for this?

Any help is appreciated.
Apr 30 '07 #3
r035198x
13,262 8TB
Hi,

Unlike in other databases, a schema in oracle is equivalent to a user. So if you create a user , then Oracle automatically creates a schema for the user. When a user logs into oracle, all the tables, procedures, functions , views etc.. that he creates or modifies will be belonging to his schema(unless he has those privileges to other's schemas). A schema is not a place where the database objects are stored. It is rather a reference to a user with his specified privileges and grants on the database.

I had a tough time with this concept as I was working on DB2 earlier and was able to create multiple schemas for a user. When I started porting the application to Oracle, I came across this problem(well it was a problem to me) of Schema = user . I really wanted to have more than one schema for a user with different set of privileges for each of them. But I ended up creating multiple users instead.

Does anyone has any opinions or suggestions for this?

Any help is appreciated.
I'm in a similar position (coming from DB2 to Oracle).
May 1 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: Jeff Lambert | last post by:
Using Oracle 8i on Win2k. Here's my problem: I can connect with SYS and can select from any table from schema JEFFX by prefixing tables with said schema name. eg: SELECT * FROM JEFFX.PROJ; ...
2
by: Andreas Bergmeier | last post by:
Hi - I searched quite a bit now but still it seems that one topic was never brought up on oracles xml handling (9i btw). Could anybody tell me how it is possible to create a table out of a xml...
9
by: Chad Smith | last post by:
Hello, I'm relatively new to the database world so please forgive me in advance for my ignorance. I have recently been tasked at my job with finding a tool that will perform the following tasks:...
0
by: John | last post by:
I realize this may be too Oracle specific for this forum-- but I've seen a fair amount of postings related to ORacle 9i's XML capabilites so I thought I'd give it a shot. So, I've read in...
1
by: Anna | last post by:
Hi all. I need to parse an XML Schema and get the following information out of it: list of elements allowed in schema list of attributes for each element - which are required and which optional...
3
by: william_hulse | last post by:
The general process i am currently working on is this: STEP 1 xml doc1 is transformed using stylesheet1 to produce xml doc2 - xml doc1 has a namespace declaration as follows... <?xml...
5
by: dave71 | last post by:
Hi Could someone please advise me how to remove the schema name from linked tables within Access. For example when I connect to a Oracle database via Microsoft ODCB for Oracle the list of...
2
by: zwasdl | last post by:
I'm using access to connect to Oracle via ODBC. I can also connect to Oracle via sql*plus. Can I write a query to join tables from different schema? If so, how? Thanks a million! Wei
13
by: Martin Z | last post by:
I'm making a CRUD screen for an Oracle database... but problem is that the primary key in that table is populated via an autonumber, which in Oracle is done just with triggers and sequences. ...
1
by: Debabrata Jana | last post by:
Hi, I am using Oracle 10g as a database server. I have two schema suppose s1 and s2. Suppose, I login to the s1 schema and as well as s2 schema. These two connection is active in two...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.