David,
i think, you can do
GRANT SELECT,INSERT ON <table> TO [EMAIL PROTECTED] identified by "password"
to allow only SELECTS/INSERTS on the table or just SELECTS with GRANT
SELECT ON ...
or did i get you wrong?
Am 12:27 19.03.2001 schrieb David Bouw:
>*This message was transferred with a trial version of CommuniGate(tm) Pro*
>Hi Sven,
>
>Yes, I just started playing with the GRANT syntax..
>Only problem is that they first define a user with everything on 'N'
>
>And then they define a table in the DB with everything on Y...
>Problem is that you have to do this for all DB's which you want to allow.
>This means that newly created DB's should later be added..
>
>This is though very secure, but I am wondering if there is a way to: allow
>EVERYTHING but the following in stead of allow NOTHING but the following....
>
>Bye Bye
>David
>
>
>
> > have you tried the GRANT syntax?
> > maybe this helps
> > take a look at the grant tables afterwards
> >
> > regards
> >
> > Am 11:48 19.03.2001 schrieben Sie:
> > >Hi there..
> > >
> > >I am not understanding something how the mysql priviege system works:
> > >
> > >I want to do the following:
> > >
> > >Give a user access to all tables in an database (also tables which will
>be
> > >added in the future) except a
> > >few private tables like the mysql table itself
> > >
> > >This is the way I thought it should be done:
> > >
> > >Add a user: '%','username','password','Y',Y','Y','Y','Y','Y','N','N'
>etc//
> > >Then add the following to table db
> > >
> > >'%',mysql','username','N',N','N','N','N','N','N','N' etc//
> > >
> > >Run the Flush privileges command and try it..
> > >
> > >This doesn't work! Or I am missing something..
> > >When I think logically, I can maybe understand that the DB looks at the
> > >user table and sees that the uses has access to do everything and doesn't
> > >look further at de db table..
> > >
> > >Is this correct? What is then the solution to do what I described above..
> > >
> > >I looked at the manual, but I can't seem to figure out in what order the
> > >tables are checked..
> > >Does it stop looking further when he finds permission to do something or
> > >does it stop at the first 'N'...
> > >
> > >
> > >PS: I am not planning to use the above example, but it will help me
> > >understand how the privilege system works..
> >
> > Sven Huster
> > Senior Unix System Administrator
> > *BSD, Linux, Solaris
> >
> >
Sven Huster
Senior Unix System Administrator
*BSD, Linux, Solaris
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
