Re: roles in the Pear DSN

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