Re: [DEVELOPER2000] ABOUT PRIVILEGE?
From: Arie Mars <arie_at_pca-online.nl>
Date: Thu, 18 Nov 1999 09:23:43 +0100
Message-ID: <810d6j$r1b$1_at_reader1.wxs.nl>
BEGIN
FOR c1rec IN c1 LOOP
END LOOP; RETURN FALSE;
END; peter wrote in message <382A2768.D3364A48_at_hmc.com.tw>...
>HI.
> I have a form which contains many functions
> I want set privilge management .
> That is to say user-A can use A form user-B can use all-form
> how to design this form?
>
>
Received on Thu Nov 18 1999 - 09:23:43 CET
Date: Thu, 18 Nov 1999 09:23:43 +0100
Message-ID: <810d6j$r1b$1_at_reader1.wxs.nl>
You can use ROLES in the database (Oracle8) and query them:
SELECT GRANTED_ROLE FROM USER_ROLE_PRIVS
Example:
FUNCTION granted_to_role(role VARCHAR2) RETURN BOOLEAN IS
CURSOR c1 IS SELECT GRANTED_ROLE
FROM USER_ROLE_PRIVS;
BEGIN
FOR c1rec IN c1 LOOP
IF UPPER(role) = UPPER(c1rec.GRANTED_ROLE) THEN RETURN TRUE; END IF;
END LOOP; RETURN FALSE;
END; peter wrote in message <382A2768.D3364A48_at_hmc.com.tw>...
>HI.
> I have a form which contains many functions
> I want set privilge management .
> That is to say user-A can use A form user-B can use all-form
> how to design this form?
>
>
Received on Thu Nov 18 1999 - 09:23:43 CET