v11 session authorization

Posted in 2008

Topics: Security, Permissions & Auditing

Peter_Logan@spartanstores.com — Fri, 08 Feb 2008 19:39:02 — source: IIUG Forums & Mailing Lists

Hello ... I know I can find this in a manual or online somewhere ... but I'm not able to do that right now .. so, hopefully nobody will tell me to read the manual ... In v11 ... with a new database that is created .. informix no longer can switch sessions unless specifically granted that privilege... Can someone please send me the grant statement that the db security admin would grant ... thanks! Peter

↪ replying to Peter_Logan@spartanstores.com

Marcus Haarmann — Fri, 08 Feb 2008 20:35:58 — source: IIUG Forums & Mailing Lists

Hi, What do you mean by "switch session" ? Select a different database at runtime ? Become another user ? Which environment are you in (dbaccess, application, which programming language ?) What is the error message you get on which command ? Sorry, without a more detailed description of your problem we cannot help you ! Marcus -----Original Message----- From: Peter_Logan@spartanstores.com [mailto:Peter_Logan@spartanstores.com] Sent: Friday, February 08, 2008 8:39 PM To: ids@iiug.org Subject: v11 session authorization [11257] Hello ... I know I can find this in a manual or online somewhere ... but I'm not able to do that right now .. so, hopefully nobody will tell me to read the manual ... In v11 ... with a new database that is created .. informix no longer can switch sessions unless specifically granted that privilege... Can someone please send me the grant statement that the db security admin would grant ... thanks! Peter ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!!

↪ replying to Marcus Haarmann

Peter_Logan@spartanstores.com — Fri, 08 Feb 2008 21:30:02 — source: IIUG Forums & Mailing Lists

dbaccess.... set session authorization to 'username'; In v11 with a new database this privilege has to be granted by the dbsecadm ... just don't remember the grant statement.... "Marcus Haarmann" <marcus.haarmann@midoco.de> Sent by: ids-bounces@iiug.org 02/08/2008 03:38 PM Please respond to ids@iiug.org To ids@iiug.org cc Subject RE: v11 session authorization [11259] Hi, What do you mean by "switch session" ? Select a different database at runtime ? Become another user ? Which environment are you in (dbaccess, application, which programming language ?) What is the error message you get on which command ? Sorry, without a more detailed description of your problem we cannot help you ! Marcus -----Original Message----- From: Peter_Logan@spartanstores.com [mailto:Peter_Logan@spartanstores.com] Sent: Friday, February 08, 2008 8:39 PM To: ids@iiug.org Subject: v11 session authorization [11257] Hello ... I know I can find this in a manual or online somewhere ... but I'm not able to do that right now .. so, hopefully nobody will tell me to read the manual ... In v11 ... with a new database that is created .. informix no longer can switch sessions unless specifically granted that privilege... Can someone please send me the grant statement that the db security admin would grant ... thanks! Peter ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!! ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!!

↪ replying to Peter_Logan@spartanstores.com

Manoj Mohan — Fri, 08 Feb 2008 21:58:28 — source: IIUG Forums & Mailing Lists

As dbsecadm one needs to execute GRANT SETSESSIONAUTH ON lynette, manoj TO sam; and then sam can assume the identity of lynette or manoj by using set session authorization statement Manoj = "Peter_Logan@spar = tanstores.com" = <Peter_Logan@spar = To tanstores.com> ids@iiug.org = Sent by: = cc ids-bounces@iiug. = org Subj= ect RE: v11 session authorization = [11260] = 02/08/2008 03:30 = PM = = = Please respond to = ids@iiug.org = = = dbaccess.... set session authorization to 'username'; In v11 with a new database this privilege has to be granted by the dbsecadm ... just don't remember the grant statement.... "Marcus Haarmann" <marcus.haarmann@midoco.de> Sent by: ids-bounces@iiug.org 02/08/2008 03:38 PM Please respond to ids@iiug.org To ids@iiug.org cc Subject RE: v11 session authorization [11259] Hi, What do you mean by "switch session" ? Select a different database at runtime ? Become another user ? Which environment are you in (dbaccess, application, which programming language ?) What is the error message you get on which command ? Sorry, without a more detailed description of your problem we cannot help you ! Marcus -----Original Message----- From: Peter_Logan@spartanstores.com [mailto:Peter_Logan@spartanstores.com] Sent: Friday, February 08, 2008 8:39 PM To: ids@iiug.org Subject: v11 session authorization [11257] Hello ... I know I can find this in a manual or online somewhere ... but I'm not able to do that right now .. so, hopefully nobody will tell me to read the manual ... In v11 ... with a new database that is created .. informix no longer ca= n switch sessions unless specifically granted that privilege... Can someone please send me the grant statement that the db security admin would grant ... thanks! Peter ***********************************************************************= * ******* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!! ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!! ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf! Registration Now Open!! =

↪ replying to Manoj Mohan

Peter_Logan@spartanstores.com — Fri, 08 Feb 2008 22:05:34 — source: IIUG Forums & Mailing Lists

Perfect ... thanks! "Manoj Mohan" <manojm@us.ibm.com> Sent by: ids-bounces@iiug.org 02/08/2008 05:01 PM Please respond to ids@iiug.org To ids@iiug.org cc Subject RE: v11 session authorization [11261] As dbsecadm one needs to execute GRANT SETSESSIONAUTH ON lynette, manoj TO sam; and then sam can assume the identity of lynette or manoj by using set session authorization statement Manoj = "Peter_Logan@spar = tanstores.com" = <Peter_Logan@spar = To tanstores.com> ids@iiug.org = Sent by: = cc ids-bounces@iiug. = org Subj= ect RE: v11 session authorization = [11260] = 02/08/2008 03:30 = PM = = = Please respond to = ids@iiug.org = = = dbaccess.... set session authorization to 'username'; In v11 with a new database this privilege has to be granted by the dbsecadm ... just don't remember the grant statement.... "Marcus Haarmann" <marcus.haarmann@midoco.de> Sent by: ids-bounces@iiug.org 02/08/2008 03:38 PM Please respond to ids@iiug.org To ids@iiug.org cc Subject RE: v11 session authorization [11259] Hi, What do you mean by "switch session" ? Select a different database at runtime ? Become another user ? Which environment are you in (dbaccess, application, which programming language ?) What is the error message you get on which command ? Sorry, without a more detailed description of your problem we cannot help you ! Marcus -----Original Message----- From: Peter_Logan@spartanstores.com [mailto:Peter_Logan@spartanstores.com] Sent: Friday, February 08, 2008 8:39 PM To: ids@iiug.org Subject: v11 session authorization [11257] Hello ... I know I can find this in a manual or online somewhere ... but I'm not able to do that right now .. so, hopefully nobody will tell me to read the manual ... In v11 ... with a new database that is created .. informix no longer ca= n switch sessions unless specifically granted that privilege... Can someone please send me the grant statement that the db security admin would grant ... thanks! Peter ***********************************************************************= * ******* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!! ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!! ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf! Registration Now Open!! = ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!!