Home » RDBMS Server » Server Administration » Different Users, Same Schema, Different Data
Different Users, Same Schema, Different Data [message #54081] Mon, 28 October 2002 19:33 Go to next message
Jerry Westhoff
Messages: 1
Registered: October 2002
Junior Member
Is there an Oracle feature or Add-On products is that let's you have multiple users access the same schema, but only see their own data?

The problem is that I don't want to manage duplicate copies of all the tables for each person's database login.

Thank you.

Report message to a moderator

Re: Different Users, Same Schema, Different Data [message #54084 is a reply to message #54081] Mon, 28 October 2002 23:01 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Yes, you can accomplish this in several ways:
1. You could create a view which contains the criteria to make sure everyone sees only his own data.
2. You could use Fine-Grained Access control and Application Contexts.

The second way is perhaps more complicated but also more secure. I good start would be here:
http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/appdev.920/a96590/adgsec02.htm.

One of the key features of Oracle is security, and I'm sure there are even more possibilities to accomplish what you want.

One thing is sure though: don't copy the data for every user!

If you look at the documents at OTN (http://otn.oracle.com/docs), you'll find more info.

HTH,
MHE

Report message to a moderator

Previous Topic: Select data from Access database
Next Topic: TNS could not resolve service name on Mac OS X
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 03:59:26 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.