ORACLE 10g

1 – Gerenciamento de Usuários

1.1 – Criando o ambiente de desenvolvimento para os usuários

mkdir -p /oracle/tbs
chown oracle.dba /oracle/tbs/* -R

1.2 – Criando um usuário

SQL> create user nickollas identified by "123456";
SQL> grant create session to nickollas;

1.3 – Apagando um usuário

SQL> drop user lancelot;

1.4 – Visualizando os usuários

SQL> select username, account_status from dba_users

2 where account_status=’OPEN’;

1.5 – Concedendo permissões à um usuário

– Roles

SQL> grant connect, resource to nickollas;

– System Privileges

SQL> grant all privileges to nickollas;

1.6 – Criando uma Tablespace

SQL> create tablespace tbs_nickollas

2 datafile ‘/oracle/tbs/df_nickollas.sbf’
3 size 5m reuse autoextend on next 5m maxsize 150m;

1.7 – Definindo a Tablespace padrão de um usuário

SQL> alter user nickollas default tablespace tbs_nickollas;
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s