开发者

sql authenatication

开发者 https://www.devze.com 2023-03-19 18:41 出处:网络
I am developing a application where the data will go and store in the database after completing my application database will be handle by the system administrator of the company he may change the data

I am developing a application where the data will go and store in the database after completing my application database will be handle by the system administrator of the company he may change the data I have problem like the system administr开发者_运维知识库ator will take care of the database once we develop the application the database will be handled by him now i want to restrict him from modifying data like inserting,updating,deleting data from database

how can i do that

any1 help me on this


If you create a new user:

See: http://dev.mysql.com/doc/refman/5.5/en/adding-users.html

You can grant and revoke privileges on your database by using the

GRANT and REVOKE keywords

See: http://dev.mysql.com/doc/refman/5.5/en/grant.html
And: http://dev.mysql.com/doc/refman/5.5/en/revoke.html

0

精彩评论

暂无评论...
验证码 换一张
取 消