开发者

sql authenatication

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜