List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:October 13 2000 8:53pm
Subject:Re: Fwd: Re: how to restrict a user to one and only one DB---HELP
View as plain text  
At 12:11 PM -0700 10-13-2000, Shakaib Sayyid wrote:
>I tried using GRANT but still I am able to do describe tables and do 
>SQL queries on DB's that are not mine.

That will happen if you use GRANT without removing the (too-permissive)
privileges that you've already set up.

>
>(I need to get a copy of the MySQL book).

No argument here. :-)

>
>Thanks
>
>On Fri, 13 Oct 2000 12:25:17 -0700, Ian Gan wrote:
>
>>Try:
>>
>>GRANT ALL ON database_name.* TO username@stripped IDENTIFIED by
>>"password"
>>
>>See pg. 422 in Paul Dubois's MYSQL book - ian
>>
>>----- Original Message -----
>>From: Shakaib Sayyid <shakaib@stripped>
>>To: <mysql@stripped>
>>Sent: Friday, October 13, 2000 12:29 AM
>>Subject: how to restrict a user to one and only one DB---HELP
>>
>>
>>
>>I have just set a MySQL db on a RH6.2 DB and its working fine.
>>
>>However, I am not able to set a user so that he STRICTLY can access only one
>>db he is assgined to.
>>
>>I have done it the follwoing way:
>>
>>insert into user(host,user,password) values('217.207.217.234', 'sjs',
>>password('123'));
>>insert into db (host,db,user) values('217.207.217.234', 'forum','sjs');
>>
>>and the rest the fields set to N in user and to Y in db. The strange thing
>>is that I have MySQLWinAdmin (an MS-Win db admin), using which if I connect
>>to
>>the db then I am able to see all the other db's, well I cannot make any
>>changes but I can see what all is there in other db's (apart from forum).
>>
>>How can I avoid this, like just have the user sjs who should be able to see
>>only his own db like forum in this case. And the other dbs should be
>>completely
>  >hidden to him.


-- 
Paul DuBois, paul@stripped
Thread
Fwd: Re: how to restrict a user to one and only one DB---HELPShakaib Sayyid13 Oct
Re: Fwd: Re: how to restrict a user to one and only one DB---HELPPaul DuBois13 Oct