AD

oracle database create user rights

1 Create User
create user zhaozhi3758 identified by 123

2 to give permission
grant resource, connect, dba to zhaozhi3758

3 Delete the user
drop user zhaozhi3758 cascade
标签: cascade, oracle, oracle database
分类: Database
时间: 2011-02-15

相关文章

  1. oracle database create table space, user, authorization, import and export dmp

    / / Create a temporary table space create temporary tablespace zfmi_temp tempfile 'D: \ oracle \ oradata \ zfm ...
  2. mysql sql oracle database create database statement of three different points

    mysql follows: create database cronie; sql server under the two: One is the default : create database cronie; ...
  3. [Oracle Database] create user

    Connection: http://samwong.javaeye.com/admin/blogs/833869 SYSTEM user with access to SQLPLUS, and: CREATE USER ...
  4. [Oracle Database] create a table space

    Connection: http://samwong.javaeye.com/blog/833871 create tablespace tablespace name logging datafile '.. \ da ...
  5. [Transfer] the oracle database link under the comprehensive summary of how to create

    [Transfer] in oracle How to create a database link under the comprehensive summary of the physical network of ...
  6. Table space design to enhance the use Oracle database performance [turn]

    Oracle database tablespace put forward innovative design concept, which for the Oracle database to make indeli ...
  7. [Turn] on how to create oracle database link a comprehensive summary

    [Turn] on how to create oracle database link on a comprehensive summary of the physical network of more than o ...
  8. Manually create the Oracle database

    System environment: 1, the operating system: Windows 2000 Server 2, Database: Oracle 8i R2 (8.1.6) for NT Ente ...
  9. Oracle Database 10g SQL Developer's Guide Chapter 10 to create the table. Sequence. Indexes and view excerpts

    Chapter 10 Create a table. Sequence . Indexes and views Alter table You can also enable or disable constraints ...
  10. Create and delete Oracle database link

    [Quote from:] http://www.mydigitallife.info/2006/01/14/oracle-database-link/ In distributed Oracle environment ...
  11. Detailed: Database name instance name. ORACLE_SID. Database domain, and the global database name service name and a script to create oracle database manually

    Database name, instance name, database name, global database name, service name, These are a few confusing to ...
  12. Oracle Database 10g Special Edition: Not only for beginners

    Analysis: Lewis Cunningham Oracle Database XE is not necessarily only for beginners, students, hobbyists or sm ...
  13. exp and imp usage and description - oracle database

    EXP Export Example: E: \ software> D: \ oracle \ product \ 10.2.0 \ db_2 \ BIN \ exp user / pw @ test file ...
  14. Oracle Database 10g Express Edition Installation Summary

    racle Database 10g Express Edition Installation Summary Part from http://hi.baidu.com/king_m, to express my gr ...
  15. Oracle database export (exp) / import (imp)

    exp Each object within the database as binary into a dmp file to download, to facilitate data migration. buffe ...
  16. Oracle Database provides a variety of security measures

    Oracle-safety measures in three main aspects, one user ID and identification; Second, an authorization and ins ...
  17. Oracle database security

    Note: The following measures is to strengthen the security of oracle access, preventing illegal user oracle of ...
  18. Oracle Database Backup and Restore (Export, Import)

    Oracle Database Backup (export) steps: 1. Oracle database export using the command exp username / password @ o ...
  19. oracle database import and export order

    Import and export utility for the implementation of the logical database backup and restore utility will expor ...