Re: roles in the Pear DSN

On Fri, 2002-02-01 at 14:11, shaun wrote: > > > Tomas V.V.Cox wrote: > > >"Stig S. Bakken" wrote: > > > >>On Thu, 2002-01-31 at 22:48, shaun X core wrote: > >> > >>>Hello, > >>> > >>>This is my first message to the php.pear.dev group, so first of all I'd > >>>like to say I have found it incredibally usefull and some of the best > >>>php code I have worked with. Which brings me to my next point. It was > >>>fine up until I realized I was going to need to have users log in with > >>>different roles (using interbase), anyway I went ahead and changed the > >>>ibase.php and db.php files, both of which I found very readable and > >>>simple to alter with out changing coding format etc. It works for > >>>interbase, but I have not yet tried roles on mssql or oracle. I was just > >>>wondering if it was worth me adding role to the DSN or not? I modified > >>>parseDSN so that it looks for the role after the password i.e > >>>user:pass:role ... Are there allready plans to implement roles into the > >>>DSN or am I missing something obvious as to why it doesnt allready? > >>>thanks -shaunXcore > >>> > >>Not being familiar with InterBase, I never knew there was such a thing > >>as roles when connecting to a database. I wonder if this could be > >>implemented as a protocol option to avoid cluttering the DSN string > >>format. What do you think, Tomas? > >> > > > >I guess that the "role" option in connect it's only supported by > >Interbase. Perhaps it's a good time to implement the "special backend > >options" we were discussing time ago. Remember Stig?: > > > >ibase://user:pass@localhost/database?role=foo&dialect=bar > > > > > >Tomas V.V.Cox > > > Actually, Interbase, MSSQL, and Oracle all support roles. They are a > very effective way to manage permissions. The "special backend options" > method sounds fine to me though. -sXcore I know about roles in Oracle etc, but is the point here that you can specify a role when logging in that would not be available otherwise? How do these two types of roles relate? - Stig