Re: User Level Access Control Priviledges

On Thu, 12 Aug 2004 17:50:44 -0400, trystano@aol.com <trystano@aol.com> 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--