grant alter system to linder;
grant audit system to linder;
grant create session to linder;
grant alter session to linder;
grant restricted session to linder;
grant debug connect session to linder;
grant create tablespace to linder;
grant alter tablespace to linder;
grant manage tablespace to linder;
grant drop tablespace to linder;
grant unlimited tablespace to linder;
grant create user to linder;
grant become user to linder;
grant alter user to linder;
grant drop user to linder;
grant create rollback segment to linder;
grant alter rollback segment to linder;
grant drop rollback segment to linder;
grant create table to linder;
grant create any table to linder;
grant alter any table to linder;
grant backup any table to linder;
grant drop any table to linder;
grant lock any table to linder;
grant comment any table to linder;
grant select any table to linder;
grant insert any table to linder;
grant update any table to linder;
grant delete any table to linder;
grant under any table to linder;
grant flashback any table to linder;
grant create cluster to linder;
grant create any cluster to linder;
grant alter any cluster to linder;
grant drop any cluster to linder;
grant create any index to linder;
grant alter any index to linder;
grant drop any index to linder;
grant create synonym to linder;
grant create any synonym to linder;
grant drop any synonym to linder;
grant create public synonym to linder;
grant drop public synonym to linder;
grant create view to linder;
grant create any view to linder;
grant drop any view to linder;
grant under any view to linder;
grant merge any view to linder;
grant drop any materialized view to linder;
grant create materialized view to linder;
grant create any materialized view to linder;
grant alter any materialized view to linder;
grant create sequence to linder;
grant create any sequence to linder;
grant alter any sequence to linder;
grant drop any sequence to linder;
grant select any sequence to linder;
grant create database link to linder;
grant create public database link to linder;
grant drop public database link to linder;
grant alter database to linder;
grant administer database trigger to linder;
grant export full database to linder;
grant import full database to linder;
grant create role to linder;
grant drop any role to linder;
grant grant any role to linder;
grant alter any role to linder;
grant force transaction to linder;
grant force any transaction to linder;
grant select any transaction to linder;
grant create procedure to linder;
grant create any procedure to linder;
grant alter any procedure to linder;
grant drop any procedure to linder;
grant execute any procedure to linder;
grant debug any procedure to linder;
grant create trigger to linder;
grant create any trigger to linder;
grant alter any trigger to linder;
grant drop any trigger to linder;
grant create profile to linder;
grant alter profile to linder;
grant drop profile to linder;
grant drop any sql profile to linder;
grant alter any sql profile to linder;
grant create any sql profile to linder;
grant create type to linder;
grant create any type to linder;
grant alter any type to linder;
grant drop any type to linder;
grant execute any type to linder;
grant under any type to linder;
grant create any directory to linder;
grant drop any directory to linder;
grant create library to linder;
grant create any library to linder;
grant alter any library to linder;
grant drop any library to linder;
grant execute any library to linder;
grant create operator to linder;
grant create any operator to linder;
grant alter any operator to linder;
grant drop any operator to linder;
grant execute any operator to linder;
grant create indextype to linder;
grant create any indextype to linder;
grant alter any indextype to linder;
grant drop any indextype to linder;
grant execute any indextype to linder;
grant create dimension to linder;
grant create any dimension to linder;
grant alter any dimension to linder;
grant drop any dimension to linder;
grant manage any queue to linder;
grant enqueue any queue to linder;
grant dequeue any queue to linder;
grant query rewrite to linder;
grant global query rewrite to linder;
grant create any context to linder;
grant drop any context to linder;
grant create evaluation context to linder;
grant create any evaluation context to linder;
grant alter any evaluation context to linder;
grant drop any evaluation context to linder;
grant execute any evaluation context to linder;
grant create any outline to linder;
grant alter any outline to linder;
grant drop any outline to linder;
grant create rule set to linder;
grant create any rule set to linder;
grant alter any rule set to linder;
grant drop any rule set to linder;
grant execute any rule set to linder;
grant create rule to linder;
grant create any rule to linder;
grant alter any rule to linder;
grant drop any rule to linder;
grant execute any rule to linder;
grant administer sql tuning set to linder;
grant administer any sql tuning set to linder;
grant manage file group to linder;
grant manage any file group to linder;
grant read any file group to linder;
grant create job to linder;
grant create any job to linder;
grant create external job to linder;
grant select any dictionary to linder;
grant analyze any dictionary to linder;
grant grant any privilege to linder;
grant grant any object privilege to linder;
grant exempt access policy to linder;
grant exempt identity policy to linder;
grant alter resource cost to linder;
grant administer resource manager to linder;
grant sysdba to linder;
grant sysoper to linder;
grant audit any to linder;
grant analyze any to linder;
grant on commit refresh to linder;
grant resumable to linder;
grant advisor to linder;
grant execute any program to linder;
grant execute any class to linder;
grant manage scheduler to linder;
grant change notification to linder;
分享到:
相关推荐
Oracle用户与对象权限与系统权限 Oracle用户与对象权限与系统权限
oracle基础知识:用户、权限与角色的理解
oracle用户创建及权限设置
1查看所有用户 2查看用户或角色系统权限(直接赋值给用户或角色的系统权限) 3查看角色(只能查看...查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限) 8 查看oracle提供的系统权限9 查看一个用户的所有系统权限
关于oracle权限的一些函数,蛮有用的
Oracle创建用户权限Oracle创建用户权限Oracle创建用户权限Oracle创建用户权限
在plsql页面执行命令,可实现所有表权限的授予
实体权限:某种权限用户对其它用户的表或视图的存取权限。(是针对表或视图而言的)。 二、系统权限管理: 1、系统权限分类: DBA: 拥有全部特权,是系统最高权限,只有DBA才可以创建数据库结构。 RESOURCE:拥有...
查看ORACLE用户具有哪些角色,某个角色有哪些权限等
使用PLSQL创建Oracle数据库User用户并设置权限 主要演示了如何使用 PLSQL 创建一个 User 用户, 并使之具有创建表、修改表、访问表的权限。解决了 使用自定义用户创建表时出现的 没有表空间的访问权限的问题。
使用PLSQL 创建Oracle数据库用户并设置权限
oracle笔记控制用户权限及练习,控制用户权限,授权,收回权限等操作,有具体的代码案例!
Oracle设置用户权限,不同权限操作不同表信息。里面有其他信息。
oracle 用户、权限和角色管理,oracle 人员必看。
完整ORACLE创建表空间、用户、设置用户权限脚本,txt格式,很实用
oracle查询用户信息1.查看所有用户2.查看用户或角色系统权限3.查看角色4.查看用户对象权限5.查看所有角色
oracle用户的权限详细说明以及赋权的操作,帮助新手理解用户以及赋权的过程
oracle用户账号管理和权限控制,操作、生成
Oracle用户权限角色设置,用来在新建的数据库中添加新的用户,并为其设置权限。
Oracle 数据库用户权限管理 ORACLE 是多用户系统,它允许许多用户共享系统资源。为了保证数据库 系统的安全,数据库管理系统配置了良好的安全机制。