grant all privileges on Students.Student,Student.Course to U
来源:学生作业帮 编辑:搜搜做题作业网作业帮 分类:综合作业 时间:2024/06/28 05:16:17
grant all privileges on Students.Student,Student.Course to U2,U3错在哪里
这条语句在Oracle上是能运行的,但MS SQL是不支持这种写法,教材上的写法是SQL的标准写法.
on的后面只能接一个对象,也就是说只能分别对U2和U3进行授权.
grant all privileges on Student to U2,U3
grant all privileges on Course to U2,U3
on的后面只能接一个对象,也就是说只能分别对U2和U3进行授权.
grant all privileges on Student to U2,U3
grant all privileges on Course to U2,U3
grant all privileges on Students.Student,Student.Course to U
grant all PRIVILEGES on SC,student,Course to U2,U3 为什么不对啊
mysql> grant all privileges on *.* to root @’%’ identified b
GRANT SELECT ON Student,Course TO U2,U3; 消息 102,级别 15,状态 1,第
grant all privileges
我已经grant all privileges ON *.*TO 'NAME'@ip indetified BY 'PA
grant select on table student to zmk(zmk是用户名) 2005编译不过说 to 附
some universities have inititiated a reform to grant student
SQL语句,grent all privileges on *.* to monty@localhot identifi
All of the student 还是 All of the students?
all the student 和 all the students 的区别
是all the student还是all the students