Roles

Hi, I'm new to Informix. We are using IDS 10.0. In Microsoft SQL Server we use an "application role" to lock down the permissions on the connection for the particular role. In Informix, is there a way to lock down the permissions on the connection by using a role? The role needs to be given execute permissions only on Views and Stored Procedures, and explicitly deny access to all direct query types except for SELECT. Thanks, Ed

IDS 10 has a great online information center maintained by IBM: http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp Specifically for roles: http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.sq ls.doc/sqls803.htm HTH, Zev Berezin To: ids@iiug.org From: "ED KOSTENBAUDER" <ekostenb@cisco.com> Subject: Roles [6550] Date sent: Tue, 28 Mar 2006 13:42:02 -0500 (EST) Send reply to: ids@iiug.org <mailto:ids-request@iiug.org?subject=unsubscribe> <mailto:ids-request@iiug.org?subject=subscribe> > > Hi, > > I'm new to Informix. We are using IDS 10.0. In Microsoft SQL Server we use an > "application role" to lock down the permissions on the connection for the > particular role. In Informix, is there a way to lock down the permissions on > the connection by using a role? The role needs to be given execute permissions > only on Views and Stored Procedures, and explicitly deny access to all direct > query types except for SELECT. > > Thanks, > > Ed > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

ED KOSTENBAUDER said: > > Hi, > > I'm new to Informix. We are using IDS 10.0. In Microsoft SQL Server we use > an > "application role" to lock down the permissions on the connection for the > particular role. In Informix, is there a way to lock down the permissions > on > the connection by using a role? The role needs to be given execute > permissions > only on Views and Stored Procedures, and explicitly deny access to all > direct > query types except for SELECT. RTFM. FFS!! -- Bye now, Obnoxio Information within this post contains forward looking statements within the meaning of Section 27A of the Securities Act of 1933 and Section 21B of the S E C Act of 1934. Statements that involve discussions with respect to projections of future events are not statements of historical fact and may be forward looking statements. Don't rely on them to make a decision. The poster is not a reporting company registered under the Exchange Act of 1934. I have received a life peerage from Her Majesty, who is not an officer, minister or affiliate Labour party member. I intend to recover my loan now, which could cause the parliamentary majority to go down, resulting in losses for you. Today's Labour party has: an accumulated deficit and a reliance on loans from officers and affiliates to pay expenses. It is not an operating political party. The party is going to need financing to continue as a going concern. A failure to finance could cause the party to go out of business. This report shall not be construed as any kind of investment advice or solicitation. You can lose all your money by investing in this party.