Re: roles in the Pear DSN

"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