GRANT CREATE VIEW,CREATE TABLE,CREATE SESSION,CREATE USER,ALTER USER,DROP USER,CREATE TABLESPACE,ALTER TABLESPACE,DROP TABLESPACE,CREATE PROCEDURE,CREATE ROLE,RESOURCE TO lsz WITH ADMIN OPTION
1.WITH ADMIN OPTION 表示这些权限赋给这个用户的同时还可以管理这些权限
GRANT CREATE VIEW,CREATE TABLE,CREATE SESSION,CREATE USER,ALTER USER,DROP USER,CREATE TABLESPACE,ALTER TABLESPACE,DROP TABLESPACE,CREATE PROCEDURE,CREATE ROLE,RESOURCE TO lsz WITH ADMIN OPTION