faisal -- Thanks for the question regarding "RESTRICT USERS TO INSERT/UPDATE DATA EXCEPT THEIR PRIVILIEGES", version 9.2.0.

Submitted on 28-Apr-2008 6:48 Central time zone

Tom's latest followup | Bookmark | Bottom

Last updated 2-May-2008 7:14

You Asked

DEAR TOM

i learn a lot from this platform as a new dba
i have a situation here. i did't write code/script here because i havn't any idea that how i ask from you? i have tried to convey my..

i have a database of almost 60 tables. application developed in
FORM 6i.

i want to restrict users to update/insert data on behalf of two
categories EXECUTIVE & NON-EXECUTIVE class employees on behalf of a code in a table.

USERS1 should update/insert records of only executive (code=1)employees in
all tables

USERS2 should update/insert records of only non-executive (code=2) employees
in all tables

what will the solution for this problem

thanks in advance

faisal

and we said...

You can use fine grained access control to do this easily

http://asktom.oracle.com/pls/ask/search?p_string=fine+grained+access+control+dbms_rls

you can set up an insert and update policy that implements your "rule"

Reviews

Really helpful & userful for day to day problem of database May 2, 2008 - 1am Central time zone

Bookmark | Bottom | Top

Reviewer: faisal from pakistan

I really enjoy this platform for learning and getting my solution

May 2, 2008 - 1am Central time zone

Bookmark | Bottom | Top

Reviewer: faisal from pakistan

CREATE TABLE EMP
(EMPID NUMBER(4),
ENAME VARCHAR2(20),
GRADE NUMBER(1))
/

INSERT INTO EMP VALUES (111,¿FAISAL¿,1);
INSERT INTO EMP VALUES (222,¿AMJAD¿,2);
INSERT INTO EMP VALUES (333,¿ASHRAF¿,2);
INSERT INTO EMP VALUES (444,¿IKRAM¿,1);
INSERT INTO EMP VALUES (555,¿ASAD¿,1);
INSERT INTO EMP VALUES (666,¿ALI¿,2);
INSERT INTO EMP VALUES (777,¿JHON¿,1);
INSERT INTO EMP VALUES (888,¿SMITH¿,1);
/

USER1 should view

EMPID    ENAME    GRADE
111    FAISAL    1
444    IKRAM    1
555    ASAD    1
777    JHON    1
888    SMITH    1

USER2 should view

EMPID    ENAME    GRADE
222    AMJAD    2
333    ASHRAF    2
666    ALI    2


There are almost 50 tables in this database having additional information of employee. i have form 
6i on front end and want to restrict user to insert/update/retreive data on behalf of GRADE

Thanks 
faisal

Followup May 2, 2008 - 7am Central time zone:

and did you read my answer?????

you asked

and I already answered.

Write a Review