授予用户test创建视图的权限,并允许他继续授权给其他用户创建视图的权限,正确的命令是()
A: grant create view to test
B: evoke create view from test
C: grant create view to test with admin option
D: evoke create view from test with admin option
A: grant create view to test
B: evoke create view from test
C: grant create view to test with admin option
D: evoke create view from test with admin option
举一反三
- 创建数据库test的命令是 A: create database test; B: create table test ; C: create index test; D: Create trigger test;
- 创建数据库test的命令是 A: create database test B: create table test C: create index test
- 创建视图应当具备的权限包括 ( ) 。 A: CREATE VIEW B: USE VIEW C: SHOW VIEW D: CREATE TABLE
- 下列创建名为'test'的数据库的语句正确的是? A: create database 'test' B: CREATE DATABASE test C: create database test; D: create database 'test';
- 在student表上创建view_stu视图,正确的语句是( )。 A: CREATE VIEW view_stu IS SELECT * FROM student; B: CREATE VIEW view_stu AS SELECT * FROM student; C: CREATE VIEW view_stu SELECT * FROM student; D: CREATE VIEW SELECT * FROM student AS view_stu;