creating roles
Can we create and use "Roles" in Informix as in Oracle? If so, please let me know of the usage. Thanks Ganesh
Same usage. I think it is the exact same syntax.
CREATE ROLE myrole;
GRANT select, insert ON table TO myrole;
GRANT myrole TO user;
"GANESH RAM" <ganesh.r@fmr.com>
Sent by: forum.subscriber@iiug.org
06/02/2004 01:45 AM
To: ids@iiug.org
cc:
Subject: creating roles [3064]
Can we create and use "Roles" in Informix as in Oracle? If so, please let
me know of the usage.
Thanks
Ganesh
The
difference is by using roles. In informix you have to explizit "set
role xx" in your statements to be member of the role.
JHAYS2@sears.com wrote:
>Same usage. I think it is the exact same syntax.
>CREATE ROLE myrole;
>GRANT select, insert ON table TO myrole;
>GRANT myrole TO user;>
>
>
>
>
>
>"GANESH RAM" <ganesh.r@fmr.com>
>Sent by: forum.subscriber@iiug.org
>06/02/2004 01:45 AM
>
>
> To: ids@iiug.org
> cc:
> Subject: creating roles [3064]
>
>
>Can we create and use "Roles" in Informix as in Oracle? If so, please let
>me know of the usage.
>
>Thanks
>Ganesh
>
>
>
>
>
>
>
>
--
Gerd Kaluzinski Tel. :+49-(0)7541-585-5000
Fax :+49-(0)7541-585-5500
BYTEC GmbH mailto:support@bytec.de
Hermann-Metzger-Str.7 http://www.bytec.de
88045 Friedrichshafen
--0__=88BBE434DFC03B838f9e8a93df938690918c88BBE434DFC03B83 Content-type: multipart/alternative; Boundary="1__=88BBE434DFC03B838f9e8a93df938690918c88BBE434DFC03B83" --1__=88BBE434DFC03B838f9e8a93df938690918c88BBE434DFC03B83 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: quoted-printable Yes u can do so .. check out the SQL Syntax manual ...but there's one difference i.e. in Informix for each session you will have to do a SET = ROLE <role name> in order to activate that role. The syntax is very similar= to what Oracle uses. Options to do that automatically (i.e. doing the SET ROLE <role> ) a) XPS -- use the sysdbopen() procedure and put in the SET ROLE comman= d in that stored procedure. b) IDS 9.x -- use a SELECT Trigger on a table which probably all the applications use to sign on to the database .. if you don't hv a set up= like that then you'll have to change the application to include the SET= ROLE command in that. Thanx much, Rajib Sarkar Advisory Software Engineer DB2/UDB Regional Advanced Support IBM Data Management Group http://www.ibm.com/software/data/db2/udb/winos2unix/support If we all did the things we are capable of doing, we would literally astound ourselves. -- T. Edison = "GANESH RAM" = <ganesh.r@fmr.com = > = To Sent by: ids@iiug.org = forum.subscriber@ = cc iiug.org = Subj= ect creating roles [3064] = 06/01/2004 11:45 = PM = = = = = Can we create and use "Roles" in Informix as in Oracle? If so, please l= et me know of the usage. Thanks Ganesh = --1__=88BBE434DFC03B838f9e8a93df938690918c88BBE434DFC03B83 Content-type: text/html; charset=US-ASCII Content-Disposition: inline Content-transfer-encoding: quoted-printable <html><body> <p>Yes u can do so .. check out the SQL Syntax manual ...but there's on= e difference i.e. in Informix for each session you will have to do a SE= T ROLE <role name> in order to activate that role. The syntax is= very similar to what Oracle uses.<br> <br> Options to do that automatically (i.e. doing the SET ROLE <role> = )<br> <br> a) XPS -- use the sysdbopen() procedure and put in the SET ROLE comman= d in that stored procedure.<br> b) IDS 9.x -- use a SELECT Trigger on a table which probably all the ap= plications use to sign on to the database .. if you don't hv a set up l= ike that then you'll have to change the application to include the SET = ROLE command in that.<br> <br> Thanx much,<br> <br> Rajib Sarkar<br> Advisory Software Engineer<br> DB2/UDB Regional Advanced Support<br> IBM Data Management Group<br> <a href=3D"http://www.ibm.com/software/data/db2/udb/winos2unix/support"= >http://www.ibm.com/software/data/db2/udb/winos2unix/support</a><br>; <br> <br> If we all did the things we are capable of doing, we would literally as= tound ourselves. -- T. Edison<br> <br> <img src=3D"cid:10__=3D88BBE434DFC03B838f9e8a93df938@us.ibm.com" width=3D= "16" height=3D"16" alt=3D"Inactive hide details for "GANESH RAM&qu= ot; <ganesh.r@fmr.com>">"GANESH RAM" <ganesh.r@fmr.c= om><br> <br> <br> <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= <tr valign=3D"top"><td style=3D"background-image:url(cid:20__=3D88BBE43= 4DFC03B838f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid= th=3D"40%"> <ul> <ul> <ul> <ul><b><font size=3D"2">"GANESH RAM" <ganesh.r@fmr.com>= </font></b><font size=3D"2"> </font><br> <font size=3D"2">Sent by: forum.subscriber@iiug.org</font> <p><font size=3D"2">06/01/2004 11:45 PM</font></ul> </ul> </ul> </ul> </td><td width=3D"60%"> <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D88BBE434DFC03B838f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""><br> <div align=3D"right"><font size=3D"2">To</font></div></td><td width=3D"= 100%"><img src=3D"cid:30__=3D88BBE434DFC03B838f9e8a93df938@us.ibm.com" = border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> <font size=3D"2">ids@iiug.org</font></td></tr> <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D88BBE434DFC03B838f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""><br> <div align=3D"right"><font size=3D"2">cc</font></div></td><td width=3D"= 100%"><img src=3D"cid:30__=3D88BBE434DFC03B838f9e8a93df938@us.ibm.com" = border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> </td></tr> <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D88BBE434DFC03B838f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""><br> <div align=3D"right"><font size=3D"2">Subject</font></div></td><td widt= h=3D"100%"><img src=3D"cid:30__=3D88BBE434DFC03B838f9e8a93df938@us.ibm.= com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> <font size=3D"2">creating roles [3064]</font></td></tr> </table> <table border=3D"0" cellspacing=3D"0" cellpadding=3D"0"> <tr valign=3D"top"><td width=3D"58"><img src=3D"cid:30__=3D88BBE434DFC0= 3B838f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt= =3D""></td><td width=3D"336"><img src=3D"cid:30__=3D88BBE434DFC03B838f9= e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><= /td></tr> </table> </td></tr> </table> <br> <tt>Can we create and use "Roles" in Informix as in Oracle? I= f so, please let me know of the usage.<br> <br> Thanks <br> Ganesh<br> <br> </tt><br> </body></html>= --1__=88BBE434DFC03B838f9e8a93df938690918c88BBE434DFC03B83-- --0__=88BBE434DFC03B838f9e8a93df938690918c88BBE434DFC03B83 Content-type: image/gif; name="graycol.gif" Content-Disposition: inline; filename="graycol.gif" Content-ID: <10__=88BBE434DFC03B838f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 R0lGODlhEAAQAKECAMzMzAAAAP///wAAACH5BAEAAAIALAAAAAAQABAAAAIXlI+py+0PopwxUbpu ZRfKZ2zgSJbmSRYAIf4fT3B0aW1pemVkIGJ5IFVsZWFkIFNtYXJ0U2F2ZXIhAAA7 --0__=88BBE434DFC03B838f9e8a93df938690918c88BBE434DFC03B83 Content-type: image/gif;