linuxoracle用戶

『壹』 linux怎麼給oracle中用戶許可權

--//給用戶授予許可權
grant connect,resource to test;
--//刪除表空間
drop tablespace test_temp including CONTENTS and datafiles;
--//修改用戶密碼
alter user test identified by new_password;
--//刪除用戶
drop user 用戶名 cascade; --//執行該語句請小心，會級聯刪除該用戶下所有對象。
--//給用戶分配許可權
sql> grant connect to test_user;
SQL> grant resource to test_user;
SQL> grant create view to test_user;
SQL> GRANT DEBUG CONNECT SESSION TO test_user;
SQL> GRANT DEBUG ANY PROCEDURE TO test_user;

實例如下：
資料庫用戶的創建、許可權的分配
資料庫安裝完成後，有兩個系統級的用戶:
1、system 默認密碼為:manager
2、sys 默認密碼為:change_on_install
在安裝的資料庫目錄中找到\oracle\proct\9.2\bin 中的sqlplus程序，運行:./sqlplussystem/manager@ora9i
用system用戶創建自己的用戶、許可權;sql語句如下:
1、創建用戶:
create user username identified by pwd default tablespace users Temporary TABLESPACE Temp;
2、用戶授權
grant connect,resource,dba to business;
3、提交
commit;

『貳』 怎樣在linux中的oracle創建用戶名和密碼

在CRT中進入oracle
--連接sqlplus
按照下面寫完代碼直接復制進去回車就行了
---建立用戶代碼為：CREATE
USER
"用戶名字"
PROFILE
"DEFAULT"
IDENTIFIED
BY
"密碼"
DEFAULT
TABLESPACE
"指定表空間名字"
TEMPORARY
TABLESPACE
"臨時表空間"
ACCOUNT
UNLOCK;
---賦權
begin
EXECUTE
IMMEDIATE
'GRANT
SELECT
ANY
DICTIONARY
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
ALTER
ANY
TABLE
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
ALTER
SYSTEM
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
ALTER
ANY
PROCEDURE
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
CONNECT
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
CREATE
ANY
PROCEDURE
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
CREATE
ANY
TABLE
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
CREATE
ANY
INDEX
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
CREATE
DATABASE
LINK
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
CREATE
PUBLIC
DATABASE
LINK
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
CREATE
ANY
VIEW
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
CREATE
PUBLIC
SYNONYM
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
CREATE
TABLE
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
DELETE
ANY
TABLE
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
DROP
PUBLIC
DATABASE
LINK
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
DROP
ANY
TRIGGER
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
DROP
ANY
INDEX
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
DROP
ANY
PROCEDURE
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
DROP
ANY
TABLE
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
DROP
ANY
VIEW
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
CREATE
PUBLIC
SYNONYM
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
DROP
PUBLIC
SYNONYM
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
CREATE
ANY
SEQUENCE
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
EXECUTE
ANY
PROCEDURE
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
GRANT
ANY
PRIVILEGE
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
GRANT
ANY
ROLE
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
CREATE
ANY
TRIGGER
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
INSERT
ANY
TABLE
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
SELECT
ANY
DICTIONARY
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
SELECT
ANY
SEQUENCE
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
DROP
ANY
SEQUENCE
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
SELECT
ANY
TABLE
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
UNLIMITED
TABLESPACE
TO
用戶名';

『叄』 linux下oracle 用戶名和密碼是什麼

一定有設置用戶名和密碼的地方，只是你沒注意；
如果沒設置，就是默認的用戶名和密碼，如下：
sys/change_on_install
system/manager

『肆』 linux 上安裝oracle用戶怎樣設置

不太理解你的問題你的機器，只要啟動，不進行登陸的話，Oracle服務也是被啟動的，只要在client端連接Oralce就可以了吧，不需要用戶登錄另外IP的問題，如果是在你虛擬機上安裝的Oracle那麼就沒有影響，默認那個使用橋接的網路，和本地系統的網路設定關系不大

『伍』 linux 下如何創建oracle 新用戶

在CRT中進入oracle
--連接sqlplus
按照下面寫完代碼直接復制進去回車就行了
---建立用戶代碼為：CREATE
USER
"用戶名字"
PROFILE
"DEFAULT"
IDENTIFIED
BY
"密碼"
DEFAULT
TABLESPACE
"指定表空間名字"
TEMPORARY
TABLESPACE
"臨時表空間"
ACCOUNT
UNLOCK;
---賦權
begin
EXECUTE
IMMEDIATE
'GRANT
SELECT
ANY
DICTIONARY
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
ALTER
ANY
TABLE
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
ALTER
SYSTEM
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
ALTER
ANY
PROCEDURE
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
CONNECT
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
CREATE
ANY
PROCEDURE
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
CREATE
ANY
TABLE
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
CREATE
ANY
INDEX
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
CREATE
DATABASE
LINK
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
CREATE
PUBLIC
DATABASE
LINK
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
CREATE
ANY
VIEW
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
CREATE
PUBLIC
SYNONYM
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
CREATE
TABLE
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
DELETE
ANY
TABLE
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
DROP
PUBLIC
DATABASE
LINK
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
DROP
ANY
TRIGGER
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
DROP
ANY
INDEX
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
DROP
ANY
PROCEDURE
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
DROP
ANY
TABLE
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
DROP
ANY
VIEW
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
CREATE
PUBLIC
SYNONYM
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
DROP
PUBLIC
SYNONYM
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
CREATE
ANY
SEQUENCE
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
EXECUTE
ANY
PROCEDURE
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
GRANT
ANY
PRIVILEGE
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
GRANT
ANY
ROLE
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
CREATE
ANY
TRIGGER
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
INSERT
ANY
TABLE
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
SELECT
ANY
DICTIONARY
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
SELECT
ANY
SEQUENCE
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
DROP
ANY
SEQUENCE
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
SELECT
ANY
TABLE
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
UNLIMITED
TABLESPACE
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
UPDATE
ANY
TABLE
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
COMMENT
ANY
TABLE
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
CREATE
ANY
TYPE
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
CREATE
TABLESPACE
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
CREATE
USER
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
EXP_FULL_DATABASE
TO
用戶名';
EXECUTE
IMMEDIATE
'GRANT
IMP_FULL_DATABASE
TO
用戶名';
End;
---或者直接給DBA許可權