摘要： DDLData Definition Language (DDL) statements are used to define the database structure or schema. Some examples: CREATE - to create objects in the database ALTER - alters the structure of the database DROP - delete objects from the database TRUNCATE - remove all records from a table, including all s 阅读全文

摘要： 1.创建用户create user hfy identified by hfy;2.在该用户下建表建表必须满足权限和表空间；首先连接sys账户，grant create session to hfy;//授予对话权限grant create table to hfy;//授予建表权限分配表空间：sys：alter user hfy quota 5m system(users);创建表：hfy：create table stu（id int） tablespace system(users);3.赋予权限给该用户为其他用户建表grant create any table to hfy;hfy:c 阅读全文