Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Column privileges
- Thread starter gooky
- Start date
Hi gooky,
try this.
mysql> mysql -u user_id -p mysql
mysql> INSERT INTO tables_priv
(Host,DB,User,Table_name,Column_priv)
VALUES
('localhost','mydb_name','user_id','table_name',
'Select,Insert,Update');
mysql> flush privileges
note : that user_id should already be able to login to
the sqlserver.
Cheers
Ken
--------------------------------------------------------
--------------------------------------------------------
try this.
mysql> mysql -u user_id -p mysql
mysql> INSERT INTO tables_priv
(Host,DB,User,Table_name,Column_priv)
VALUES
('localhost','mydb_name','user_id','table_name',
'Select,Insert,Update');
mysql> flush privileges
note : that user_id should already be able to login to
the sqlserver.
Cheers
Ken
--------------------------------------------------------
--------------------------------------------------------
- Status
Similar threads
- Locked
- Question