Docker安装Oracle_11g的方法

最新推荐文章于 2024-06-26 11:42:45 发布

@大吉

最新推荐文章于 2024-06-26 11:42:45 发布

阅读量50

点赞数

文章标签： oracle 数据库

原文链接：https://blog.csdn.net/qq_14852741/article/details/123679337

版权

在这里插入图片描述

export ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_2
export ORACLE_SID=helowin
export PATH=$ORACLE_HOME/bin:$PATH

在这里插入图片描述

alter user system identified by oracle;
alter user sys identified by oracle;
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

在这里插入图片描述

GRANT ALTER ANY PROCEDURE TO username;
GRANT ALTER ANY TABLE TO username;
GRANT ALTER ANY TRIGGER TO username;
GRANT ALTER ANY TYPE TO username;
GRANT CREATE ANY TABLE TO username;
GRANT DELETE ANY TABLE TO username;
GRANT DROP ANY PROCEDURE TO username;
GRANT DROP ANY SEQUENCE TO username;
GRANT DROP ANY TABLE TO username;
GRANT DROP ANY TRIGGER TO username;
GRANT DROP ANY TYPE TO username;
GRANT DROP ANY VIEW TO username;
GRANT SELECT ANY DICTIONARY TO username;
GRANT SELECT ANY SEQUENCE TO username;
GRANT SELECT ANY TABLE TO username;
GRANT UNDER ANY TABLE TO username;
GRANT UNDER ANY TYPE TO username;
GRANT UNDER ANY VIEW TO username;
GRANT UNLIMITED TABLESPACE TO username;
GRANT UPDATE ANY TABLE TO username;
GRANT CONNECT TO username;
GRANT DBA TO username;
GRANT RESOURCE TO username;
#下面两句主要用于给其他用户赋权限
GRANT insert ANY TABLE TO username;
GRANT execute ANY PROCEDURE TO username;