Privilage in oracle 10g database

30 pts.
Tags:
Oracle
Oracle 10g
Oracle administration
Oracle Database 10g
Hi everybody,

I am developing a relational database using oracle 10g. It is a centralized database. I do have four groups going to use the database. They are doing same tasks on their own part. How could I restrict them only they do have access on their own part? I am waiting for your help.

    Thanks a lot!

 

 



Software/Hardware used:
software
ASKED: March 18, 2010  1:38 PM
UPDATED: March 19, 2010  1:39 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi Girma,

In Oracle RDBMS you can use ROLEs to control access.
Grant specific privileges to each role.
Grant one or more roles to each user.

Think of a ROLE as a “group of privilges”.
Then add/remove people to these roles.
This is easier than giving each individual user the required authorizations.

CREATE ROLE call_taker;
GRANT some_auth, another_auth TO call_taker;

CREATE ROLE shipping_clerk;
GRANT an_auth, some_other_auth TO shipping CLERK;

GRANT call_taker TO sally; – sally is one of the call takers
GRANT call_taker TO beth; – beth is another call taker

GRANT shipping_clerk TO bill; – bill was hired to work in the shipping department.

Hope this helps.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    More details are needed. What do you mean by "their own part" ? a different schema, different tables, different operations on a common set of objects, or what ?
    65,110 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following