create user ...;
grant ... on ... to ...;
create table tablename(
field1 Varchar,
field2 Number,
...
);
grant ... on ... to ...;
create table tablename(
field1 Varchar,
field2 Number,
...
);
default tablespace users temporary tablespace temp;grant connect to username;create table tablename (a int,b varchar2)
grant
create user
给用户赋权限:
grant 权限 on 表 to 用户
建表:
create table
2.create public rollback...
3.create user ...
4.grant connect,resource to your_user.
5.create table ...
grant resource to username;create table tablename(field1 type,field2 type,...);
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a85397/statem9c.htm#2065280
授权
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a85397/state13g.htm#2063862
create user 用户 identified by gone
给用户赋权限:
grant select||insert||create on 表名 to 用户
建表命令:
create table 表名(
变量名1 变量类型,
变量名2 变量类型,
...
如有主码则要加上:primary key(变量名));