由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - 2 questions on MySQL privileges
相关主题
how to deny a user to use mysqlHelp: 如何在oracle 9i 中添加1 个user?
anonymous login in mysql?求教: dba privilage
install mysql谢谢,但是...Re: 急问MS ACCESS的问题
Cannot connect to the mysql server insidSQL SERVER 2K5 schema vs. Oracle schema
借人气问:连MySQL的问题?怎么设置多个用户 (Oracle 10g)?
How to know which database I am connected?How to allow non-sa to modify a job?
help! create database in oracleFree Database List
求教一ORACLE问题如何建基于WWW的BBS?
相关话题的讨论汇总
话题: privileges话题: mysql话题: abc话题: questions话题: revoke
进入Database版参与讨论
1 (共1页)
M*****r
发帖数: 1536
1
1. It seems if
grant all on db1.* to 'abc'@'%' identified by 'abc'
then, if I only want to revoke select from one table
revoke select on db1.tbl1 from 'abc'@'%'
it doesn't work?
2. If I drop an object (e.g. table), will the privileges granted to it be
dropped automatically?
Some old readings refer to these issue in 3.x/4.x days, have them been fixed on
5.0.x(seem doesn't work on 5.0.51a)? or will they be fixed later?
1 (共1页)
进入Database版参与讨论
相关主题
如何建基于WWW的BBS?借人气问:连MySQL的问题?
Is there any small free database support Java ?How to know which database I am connected?
how to usa mSQL?help! create database in oracle
给偶一个干活的机会,何如? 申请作Database板副求教一ORACLE问题
how to deny a user to use mysqlHelp: 如何在oracle 9i 中添加1 个user?
anonymous login in mysql?求教: dba privilage
install mysql谢谢,但是...Re: 急问MS ACCESS的问题
Cannot connect to the mysql server insidSQL SERVER 2K5 schema vs. Oracle schema
相关话题的讨论汇总
话题: privileges话题: mysql话题: abc话题: questions话题: revoke