Whoever Resembles a People is One of Them. He is not one of us who resembles other than us,
nor who resembles the Jews nor the Christians.(jami-at-tirmidhi-vol-5-ahadith-2695)
O you who believe (who wish to reach ALLAH C.C. before death)! Do not take my and
your enemies for friends!
And although they have denied what has come to you
from the Truth, you still love them (treating them as your friends).
If you go forth to struggle hard in My Way, seeking My Pleasure, (then why) you manifest
love to them and share with them your secrets.
And I know what you conceal and what you manifest. And whoever of you does that, then he
indeed has gone astray from the right Way. 60/Al-Mumtahanah-1
They are driving out the Messenger and yourselves from your land because you
believe in ALLAH C.C., your Lord.
Recite (read and explain to others) that which has been revealed to you of the Book
and keep up the Prayer.
Surely the Prayer keeps away from Al-Fahsh (to do what ALLAH C.C. prohibits) and Al-Munkar
(to deny what ALLAH C.C. commands).
Whoever obeys me, obeys ALLAH C.C., and whoever disobeys me, disobeys ALLAH C.C.
Whoever obeys the ruler, obeys me, and whoever disobeys the ruler, disobeys me. " (Sahih)

Kullanici Role ve Haklar

Kullanıcı Yönetimi

Kullanıcı oluşturma

CREATE USER omer IDENTIFIED BY sifreniz
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE temp
QUOTA UNLIMITED ON users;


Hak verme
GRANT connect TO omer;
GRANT create table, create procedure TO omer;

Kullanıcı kitleme ve kilidi açma
alter user kullanıcı_ismi account lock;
alter user kullanıcı_ismi account unlock;

şifre tanımlama
alter user kullanıcı_adı identified by yeni_sifre;
ALTER USER kullanıcı_ismi IDENTIFIED BY yeni_sifre ACCOUNT UNLOCK;

Kaç başarısız login işleminden sonra sistem hesap kilitlensin

ALTER PROFILE “DEFAULT” LIMIT FAILED_LOGIN_ATTEMPTS DEFAULT
ALTER PROFILE “DEFAULT” LIMIT FAILED_LOGIN_ATTEMPTS 9

Kaç dakika idle kalan kullanıcının oturumu (session) sonlandırılsın
ALTER PROFILE “DEFAULT” LIMIT IDLE_TIME 15 –(resource_limit = default da false dur. true yapmadan limitler devreye girmez.)

Kullanıcıları listeler

set pages 999 lines 100
col username format a20
col status format a8
col tablespace format a20
col temp_ts format a20
select username
, account_status status
, created
, default_tablespace tablespace
, temporary_tablespace temp_ts
from dba_users
order by username

Roller (Roles)

select *
from dba_roles
where role like ‘&role’

Kullanıcıya verilen roller

select grantee
, granted_role
, admin_option
from dba_role_privs
where grantee like upper(‘&username’)
/

Role verilen haklar (privileges)

select privilege
, admin_option
from role_sys_privs
where role like ‘&role’

Tablo hakları hangi role verilmiş

select owner || ‘.’ || table_name “TABLE”
, column_name
, privilege
, grantable
from role_tab_privs
where role like ‘&role’

Belirli bir kulllanıcıya verilmiş haklar ve roller

SET SERVEROUTPUT ON
SET VERIFY OFF
SELECT a.granted_role “Role”,
a.admin_option “Adm”
FROM user_role_privs a;
SELECT a.privilege “Privilege”,
a.admin_option “Adm”
FROM user_sys_privs a;

Copyright © 2015 Sysdba All Rights Reserved Web Designer