grant all privileges on Students.Student,Student.Course to U2,U3错在哪里

来源:学生作业帮助网 编辑:作业帮 时间:2024/05/05 14:26:05
grant all privileges on Students.Student,Student.Course to U2,U3错在哪里

grant all privileges on Students.Student,Student.Course to U2,U3错在哪里
grant all privileges on Students.Student,Student.Course to U2,U3错在哪里

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

grant all on Students.Student,Student.Course to U2,U3
这样就代表所有权限了。。all=all privileges

有一个单词写错吗 没有数据库名,SC,student,Course 应该是表名吧,在表名的前面加上数据库名就好了,如数据名为xs,则xs.SC,xs.student,xs.

grant all privileges SQL语句,grent all privileges on *.* to monty@localhot identified by'something' with grant option mysql授权问题.Create database with same name and grant all privileges是什么意思? grant all privileges on Students.Student,Student.Course to U2,U3错在哪里 grant all PRIVILEGES on SC,student,Course to U2,U3 为什么不对啊 ALL PRIVILEGES是什么意思 我已经grant all privileges ON *.*TO 'NAME'@ip indetified BY 'PASSWORD' WITH GRANT OPTION;但是还是连不上数据库,两台机器之间的防火墙我也开了3306的例外 bachelor of arts with honours是什么意思啊bachelor of arts with honours and grant all the honours ,rights and privileges which appertain to this dree那应该说是什么专业呢 mysql> grant all privileges on *.* to root @’%’ identified by '12345678' with grant option;ERROR 1064 (42000):You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' grant是什么意思 grant是什么意思 lottery grant flush privileges什么意思 take sb along 有这样一句话:he'd been particularly intimate with General Grant so that when Grant went East to take charge of all the armies,he took father along.这里的take grant和grant-in-aid的区别 Grant and contracts Grant and contracts 英语翻译CURTIN UNIVERSITY OF THECNOLOGYBY AUTHORITY OF THE COUNCIL BE IT KNOWN THATJACK TAIHAVING FULFILLED ALL THE REQUIREMENTS IS DULYADMITTED TO THE DEGREE OFBACHELOR OF COMMERCEACCOUNTING AND FINANCEWITH DISTINCTIONAND TO ALL THE PRIVILEGES A under-grant-number是什么意思