下面使用DELETE语句删除用户user2的语句中,正确的是 A: DELETE FROM mysql.user WHERE Host='localhost' AND User='user2'; B: DELETE FROM mysql.user WHILE Host='localhost' AND User='user2'; C: DELETE FROM mysql.user WHERE Host='localhost' OR User='user2'; D: DELETE FROM mysql.user WHILE Host='localhost' OR User='user2';
下面使用DELETE语句删除用户user2的语句中,正确的是 A: DELETE FROM mysql.user WHERE Host='localhost' AND User='user2'; B: DELETE FROM mysql.user WHILE Host='localhost' AND User='user2'; C: DELETE FROM mysql.user WHERE Host='localhost' OR User='user2'; D: DELETE FROM mysql.user WHILE Host='localhost' OR User='user2';
使用CREATE USER语句创建一个新用户,用户名为user2、密码为123 下面选项中,能实现上述功能的语句是 A: CREATE USER 'user2'@'localhost' IDENTIFIED BY '123'; B: CREATE USER user2@localhost IDENTIFIED BY 123; C: CREATE USER 'user2'@'localhost' IDENTIFIED TO '123'; D: CREATE USER user2@localhost IDENTIFIED TO '123';
使用CREATE USER语句创建一个新用户,用户名为user2、密码为123 下面选项中,能实现上述功能的语句是 A: CREATE USER 'user2'@'localhost' IDENTIFIED BY '123'; B: CREATE USER user2@localhost IDENTIFIED BY 123; C: CREATE USER 'user2'@'localhost' IDENTIFIED TO '123'; D: CREATE USER user2@localhost IDENTIFIED TO '123';
You have an Exchange Server 2010 organization.You have a user named User1 and a user named User2. You need to ensure that User1 can add User2 to the From field when he sends e-mail messages. Messages that have User2 in the From field must display only User2 as the message sender to recipients Who receive the messages. What should you use?() A: Active Directory Users and Computers B: Exchange Control Panel (ECP) C: Exchange Management Console (EMC) D: Microsoft Office Outlook
You have an Exchange Server 2010 organization.You have a user named User1 and a user named User2. You need to ensure that User1 can add User2 to the From field when he sends e-mail messages. Messages that have User2 in the From field must display only User2 as the message sender to recipients Who receive the messages. What should you use?() A: Active Directory Users and Computers B: Exchange Control Panel (ECP) C: Exchange Management Console (EMC) D: Microsoft Office Outlook
如果要删除C盘FOX子目录下的USER子目录,应该如何操作() A: 第一步:先将USER子目录下的文件删空C:\>DELC:\FOX\USER\. B: 第二步,删除USER子目录2)C:\>RDC:\FOX\USER C: 第一步:先将USER子目录下的文件删空C:\>RDC:\FOX\USER\. D: 第二步,删除USER子目录2)C:\>DEL?C:\FOX\USER
如果要删除C盘FOX子目录下的USER子目录,应该如何操作() A: 第一步:先将USER子目录下的文件删空C:\>DELC:\FOX\USER\. B: 第二步,删除USER子目录2)C:\>RDC:\FOX\USER C: 第一步:先将USER子目录下的文件删空C:\>RDC:\FOX\USER\. D: 第二步,删除USER子目录2)C:\>DEL?C:\FOX\USER
下列选项中,采用不指定表的字段名的方式向表user中添加id为2,name为”小明”的记录,正确的SQL语句是 A: INSERT INTO user(“id”,”name”) VALUES(2,”小明”); B: INSERT INTO user VALUE(2,”小明”); C: INSERT INTO user VALUES(2,’小明’); D: INSERT INTO user(id,name) VALUES(2,’小明’);
下列选项中,采用不指定表的字段名的方式向表user中添加id为2,name为”小明”的记录,正确的SQL语句是 A: INSERT INTO user(“id”,”name”) VALUES(2,”小明”); B: INSERT INTO user VALUE(2,”小明”); C: INSERT INTO user VALUES(2,’小明’); D: INSERT INTO user(id,name) VALUES(2,’小明’);
【单选题】把对Student表的全部操作权授予用户User1和User2的语句是(1.0分) A. GRANT All ON Student TO User1, User2; B. GRANT Student ON All TO User1, User2; C. GRANT All TO Student ON User1, User2; D. GRANT All TO User1, User2 ON Student;
【单选题】把对Student表的全部操作权授予用户User1和User2的语句是(1.0分) A. GRANT All ON Student TO User1, User2; B. GRANT Student ON All TO User1, User2; C. GRANT All TO Student ON User1, User2; D. GRANT All TO User1, User2 ON Student;
把对Student表和Course表的全部操作权授予用户User1和User2的语句是() A: GRANTAllONStudent,CourseTOUser1,User2; B: GRANTStudent,CourseONAllTOUser1,User2; C: GRANTAllTOStudent,CourseONUser1,User2; D: GRANTAllTOUser1,User2ONStudent,Course;
把对Student表和Course表的全部操作权授予用户User1和User2的语句是() A: GRANTAllONStudent,CourseTOUser1,User2; B: GRANTStudent,CourseONAllTOUser1,User2; C: GRANTAllTOStudent,CourseONUser1,User2; D: GRANTAllTOUser1,User2ONStudent,Course;
创建用户user2
创建用户user2
修改用户user2的主目录为/var/user2,把启动Shell修改为/bin/sh
修改用户user2的主目录为/var/user2,把启动Shell修改为/bin/sh
用户user1创建了一张表tab1,现在想让用户user2能插入数据到表tab1,请补齐赋予user2权限的语句。grant insert on to user2;
用户user1创建了一张表tab1,现在想让用户user2能插入数据到表tab1,请补齐赋予user2权限的语句。grant insert on to user2;