Oracle PL/SQL/User Previliege/Create User
Версия от 16:45, 26 мая 2010; (обсуждение)
Содержание
Create a user and drop it
<source lang="sql">
create user sqle identified by password; grant create session, dba to sqle; connect sqle/password; --DROP USER sqle;
</source>
Create user and assign password
<source lang="sql">
SQL> create user user1 identified by VALUES "1A2DD3CCEE354DFA"; SQL> SQL> SQL> drop user user1;
</source>
Create user: default tablespace, temporary tablespace, quota
<source lang="sql">
SQL> SQL> create user aNewUser
2 identified by doomed 3 default tablespace users 4 temporary tablespace temp 5 quota unlimited on users;
User created. SQL> SQL> SQL> grant create session, create table to aNewUser; Grant succeeded. SQL> SQL> connect aNewUser/doomed; Connected. SQL> SQL> create table employees_backup (
2 employee_id number, 3 last_name varchar2(30), 4 email varchar2(100) 5 );
Table created. SQL> SQL> drop table employees_backup; Table dropped. SQL>
</source>
Create User demo
<source lang="sql">
SQL> SQL> CREATE USER Bob IDENTIFIED BY mypass; User created.
</source>