济南贵和领秀城:ORACLE的权限设置
来源:百度文库 编辑:偶看新闻 时间:2024/04/28 12:34:55
创建用户
create user abc identified by 123;
----------------------------------------------------授权
grant create session,create table to abc
grant create sysdba to database----------------------------------------------------然后
conn abc
密码:123
----------------------------------------------------
登陆用户就可以建表,你也可以授权其他权限给用户。
create user username ...
grant connect to username ;
grant resource to username ;
connect username/password ;
create table tablename ...
创建表
create table
(
col1 varchar(20) not null,
col2 number(14,2) null
....
...
constraint table1_pk_col1name primary key (col2,col1)
);
例如:
create table h
(
aa varchar(20) not null,
bb number(12,2),
constraint h_pk_aa primary key (aa)
);
----------------------------------------------------插入数据
insert into hr_bm values('22','dd')
----------------------------------------------------
查看所有用户
select * from all_users;
查看所有的表
select table_name from tabs;
查看表内字段的属性
desc 与表名
desc table_name 本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/lidengzhi0000/archive/2009/04/09/4055966.aspx
create user abc identified by 123;
----------------------------------------------------授权
grant create session,create table to abc
grant create sysdba to database----------------------------------------------------然后
conn abc
密码:123
----------------------------------------------------
登陆用户就可以建表,你也可以授权其他权限给用户。
create user username ...
grant connect to username ;
grant resource to username ;
connect username/password ;
create table tablename ...
创建表
create table
(
col1 varchar(20) not null,
col2 number(14,2) null
....
...
constraint table1_pk_col1name primary key (col2,col1)
);
例如:
create table h
(
aa varchar(20) not null,
bb number(12,2),
constraint h_pk_aa primary key (aa)
);
----------------------------------------------------插入数据
insert into hr_bm values('22','dd')
----------------------------------------------------
查看所有用户
select * from all_users;
查看所有的表
select table_name from tabs;
查看表内字段的属性
desc 与表名
desc table_name 本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/lidengzhi0000/archive/2009/04/09/4055966.aspx