1.Oracle数据库的用户应配置哪些属性,只要是用profile文件进行限制用户的属性,并且在创建的时候指定profile属性 1>.failed_login_attempts 2>.password_lock_time 3>.password_lift_time 4>.password_grace_time 5>.password_reuse_time 6>.password_reuse_max 7>.password_verify_function 8>.cpu_per_session 9>.session_per_user 10>.connect_time 11>.idle_time 12>.logical_reads_pre_session 13>.private_sga 14>.cpu_per_call 15>.logical_reads_per_calls 2.请使用SQL语句,用自己的姓名(拼音)创建一个数据库用户,该用户使用自己创建的表空间,存储配额是50M create user youname identified by youpsd tablespace youtabs quota 50M profile youpfe;3.予使用dept表(scott模式)所有dml操作的权利和create table的权限,并且能够把这些权限再次授予其他用户。然后再把create table 的权限撤销。 使用sysdba的权限的用户登陆 grant create any table to youname with amdin option; revoke create any table from youname; 登陆到scott用户下 grant select,insert,update,delete on scott.dept to youname with grant option revoke select,insert,update,delete on scott.dept from youname;
CREATE USER "sunleisoft" IDENTIFIED BY "123456" DEFAULT TABLESPACE "MIS" TEMPORARY TABLESPACE "TEMP" GRANT"CONNECT" TO "sunleisoft" WITH ADMIN OPTION; GRANT"RESOURCE" TO "sunleisoft" WITH ADMIN OPTION;CREATE TABLESPACE MIS DATAFILE 'D:\MIS.dbf' SIZE 50M DEFAULT STORAGE( INITIAL 512K NEXT 512K MINEXTENTS 2 PCTINCREASE 50% MAXEXTENTS 2048 )
create user xxx identified by xxx default tablespace xxx_ts quota 50M on xxx_ts;grant create session to xxx;grant insert,delete,update on scott.dept to xxx with grant option;grant create table to xxx with admin option;revoke create table from xxx;
1>.failed_login_attempts
2>.password_lock_time
3>.password_lift_time
4>.password_grace_time
5>.password_reuse_time
6>.password_reuse_max
7>.password_verify_function
8>.cpu_per_session
9>.session_per_user
10>.connect_time
11>.idle_time
12>.logical_reads_pre_session
13>.private_sga
14>.cpu_per_call
15>.logical_reads_per_calls 2.请使用SQL语句,用自己的姓名(拼音)创建一个数据库用户,该用户使用自己创建的表空间,存储配额是50M
create user youname identified by youpsd tablespace youtabs quota 50M profile youpfe;3.予使用dept表(scott模式)所有dml操作的权利和create table的权限,并且能够把这些权限再次授予其他用户。然后再把create table 的权限撤销。
使用sysdba的权限的用户登陆
grant create any table to youname with amdin option;
revoke create any table from youname;
登陆到scott用户下
grant select,insert,update,delete on scott.dept to youname with grant option
revoke select,insert,update,delete on scott.dept from youname;
IDENTIFIED BY "123456"
DEFAULT TABLESPACE "MIS"
TEMPORARY TABLESPACE "TEMP"
GRANT"CONNECT" TO "sunleisoft" WITH ADMIN OPTION;
GRANT"RESOURCE" TO "sunleisoft" WITH ADMIN OPTION;CREATE TABLESPACE MIS
DATAFILE 'D:\MIS.dbf' SIZE 50M
DEFAULT STORAGE(
INITIAL 512K
NEXT 512K
MINEXTENTS 2
PCTINCREASE 50%
MAXEXTENTS 2048
)
create user xxx identified by xxx
default tablespace xxx_ts
quota 50M on xxx_ts;grant create session to xxx;grant insert,delete,update on scott.dept to xxx with grant option;grant create table to xxx with admin option;revoke create table from xxx;