On Thu, 12 Aug 2004 17:50:44 -0400, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > I meant be implemeting the User Access priviledges into the database, so then the > code being used will extract that this data for certain users and execute whats > necessary. > > For example... > > CREATE TABLE User ( > ID int not null > , Name varchar(30) not null > , PRIMARY KEY (ID) > ); > > CREATE TABLE AccessObject ( > ID int not null > , Description varchar(255) not null > , PRIMARY KEY (ID) > ); > > CREATE TABLE UserAccessPermission ( > User int not null > , AccessObject int not null > , CanRead char(1) not null default('Y') > , CanWrite char(1) not null default('N') > , PRIMARY KEY (User, AccessObject) > ); > > Hope this helps you grasp what I had in mind. >
LiveUser does this. -- DB_DataObject_FormBuilder - The database at your fingertips http://pear.php.net/package/DB_DataObject_FormBuilder paperCrane --Justin Patrin-- -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php