oracle基本命令 1、用户创建、修改、删除用户创建 create user username

文件名称: oracle基本命令

所属分类: Oracle

开发工具:

文件大小: 3mb

下载次数: 0

上传时间: 2011-08-31

提供者: mypass******

下载 (3mb)

不能下载？报告错误

详细说明： 1、用户创建、修改、删除用户创建 create user username profile default identified by "user_passwd" default tablespace tablespace_name account unlock; 修改用户密码： alter user username identified by char_name；修改用户使用状态 alter user username account unlock 用户赋权限： grant connect,resource,select any table,update any table,delete any table,insert any table,select any dictionary,create any procedure,execute any procedure,create any TRIGGER,create any view, unlimited tablespace， drop any view,create any sequence,select any sequence,drop any sequenc e,CREATE DATABASE LINK, CREATE PUBLIC DATABASE LINK,DROP PUBLIC DATABASE LINK,CREATE ANY synonym,DROP ANY synonym, CREATE PUBLIC synonym,DROP PUBLIC SYNONYM,SELECT_CATALOG_ROLE to &u; 给某一个用户赋予某张表的某种权限： grant privilege_name（select insert update） table_name to username; 例如： grant update ON TABLE_NAME TO username; grant delete ON TABLE_NAME TO username; grant insert ON TABLE_NAME TO username; 用户权限回收： revoke role_name from username; alter user username default role all; 用户删除： Drop user username cascade （如果有数据，带 cascade 参数）查看用户属性和状态： select * from dba_users; select * from dba_sys_privs select * from dba_tab_privs 权限名称： administer database trigger administer resource manager alter any cluster alter any dimension alter any evaluation context alter any index alter any indextype alter any library alter any outline alter any procedure alter any role alter any rule alter any rule set alter any sequence alter any snapshot alter any table alter any trigger alter any type alter database alter profile alter resource cost alter rollback segment alter session alter system alter tablespace alter user analyze any audit any audit system backup any table debug any procedure debug connect session delete any table dequeue any queue drop any cluster drop any context drop any dimension drop any directory drop any evaluation context drop any index drop any indextype drop any library drop any operator drop any outline drop any procedure drop any role drop any rule drop any rule set drop any sequence drop any snapshot drop any synonym drop any table drop any trigger drop any type drop any view drop profile drop public database link drop public synonym drop rollback segment drop tablespace become user comment any table create any cluster create any context create any dimension create any directory create any evaluation context create any index create any indextype create any library create any operator create any outline create any procedure create any rule create any rule set create any sequence create any snapshot create any synonym create any table create any trigger create any type create any view create cluster create database link create dimension create evaluation context create indextype create library create operator create procedure create profile create public database link create public synonym create role create rollback segment create rule create rule set create sequence create session create user create view ...展开收缩

(系统自动生成,下载前可以参看下载内容)