oracle用户授所有权限

grant alter system to linder;
2

grant audit system to linder;
3

grant create session to linder;
5

grant alter session to linder;
6

grant restricted session to linder;
7

grant debug connect session to linder;
8

grant create tablespace to linder;
10

grant alter tablespace to linder;
11

grant manage tablespace to linder;
12

grant drop tablespace to linder;
13

grant unlimited tablespace to linder;
14

grant create user to linder;
16

grant become user to linder;
17

grant alter user to linder;
18

grant drop user to linder;
19

grant create rollback segment to linder;
21

grant alter rollback segment to linder;
22

grant drop rollback segment to linder;
23

grant create table to linder;
25

grant create any table to linder;
26

grant alter any table to linder;
27

grant backup any table to linder;
28

grant drop any table to linder;
29

grant lock any table to linder;
30

grant comment any table to linder;
31

grant select any table to linder;
32

grant insert any table to linder;
33

grant update any table to linder;
34

grant delete any table to linder;
35

grant under any table to linder;
36

grant flashback any table to linder;
37

grant create cluster to linder;
39

grant create any cluster to linder;
40

grant alter any cluster to linder;
41

grant drop any cluster to linder;
42

grant create any index to linder;
44

grant alter any index to linder;
45

grant drop any index to linder;
46

grant create synonym to linder;
48

grant create any synonym to linder;
49

grant drop any synonym to linder;
50

grant create public synonym to linder;
51

grant drop public synonym to linder;
52

grant create view to linder;
54

grant create any view to linder;
55

grant drop any view to linder;
56

grant under any view to linder;
57

grant merge any view to linder;
58

grant drop any materialized view to linder;
59

grant create materialized view to linder;
60

grant create any materialized view to linder;
61

grant alter any materialized view to linder;
62

grant create sequence to linder;
64

grant create any sequence to linder;
65

grant alter any sequence to linder;
66

grant drop any sequence to linder;
67

grant select any sequence to linder;
68

grant create database link to linder;
70

grant create public database link to linder;
71

grant drop public database link to linder;
72

grant alter database to linder;
73

grant administer database trigger to linder;
74

grant export full database to linder;
75

grant import full database to linder;
76

grant create role to linder;
79

grant drop any role to linder;
80

grant grant any role to linder;
81

grant alter any role to linder;
82

grant force transaction to linder;
84

grant force any transaction to linder;
85

grant select any transaction to linder;
86

grant create procedure to linder;
88

grant create any procedure to linder;
89

grant alter any procedure to linder;
90

grant drop any procedure to linder;
91

grant execute any procedure to linder;
92

grant debug any procedure to linder;
93

grant create trigger to linder;
95

grant create any trigger to linder;
96

grant alter any trigger to linder;
97

grant drop any trigger to linder;
98

grant create profile to linder;
100

grant alter profile to linder;
101

grant drop profile to linder;
102

grant drop any sql profile to linder;
103

grant alter any sql profile to linder;
104

grant create any sql profile to linder;
105

106

grant create type to linder;
107

grant create any type to linder;
108

grant alter any type to linder;
109

grant drop any type to linder;
110

grant execute any type to linder;
111

grant under any type to linder;
112

113

grant create any directory to linder;
114

grant drop any directory to linder;
115

116

grant create library to linder;
117

grant create any library to linder;
118

grant alter any library to linder;
119

grant drop any library to linder;
120

grant execute any library to linder;
121

122

grant create operator to linder;
123

grant create any operator to linder;
124

grant alter any operator to linder;
125

grant drop any operator to linder;
126

grant execute any operator to linder;
127

128

grant create indextype to linder;
129

grant create any indextype to linder;
130

grant alter any indextype to linder;
131

grant drop any indextype to linder;
132

grant execute any indextype to linder;
133

134

grant create dimension to linder;
135

grant create any dimension to linder;
136

grant alter any dimension to linder;
137

grant drop any dimension to linder;
138

139

grant manage any queue to linder;
140

grant enqueue any queue to linder;
141

grant dequeue any queue to linder;
142

143

grant query rewrite to linder;
144

grant global query rewrite to linder;
145

146

grant create any context to linder;
147

grant drop any context to linder;
148

grant create evaluation context to linder;
149

grant create any evaluation context to linder;
150

grant alter any evaluation context to linder;
151

grant drop any evaluation context to linder;
152

grant execute any evaluation context to linder;
153

154

grant create any outline to linder;
155

grant alter any outline to linder;
156

grant drop any outline to linder;
157

158

grant create rule set to linder;
159

grant create any rule set to linder;
160

grant alter any rule set to linder;
161

grant drop any rule set to linder;
162

grant execute any rule set to linder;
163

grant create rule to linder;
164

grant create any rule to linder;
165

grant alter any rule to linder;
166

grant drop any rule to linder;
167

grant execute any rule to linder;
168

169

grant administer sql tuning set to linder;
170

grant administer any sql tuning set to linder;
171

172

grant manage file group to linder;
173

grant manage any file group to linder;
174

grant read any file group to linder;
175

176

grant create job to linder;
177

grant create any job to linder;
178

grant create external job to linder;
179

180

grant select any dictionary to linder;
181

grant analyze any dictionary to linder;
182

183

grant grant any privilege to linder;
184

grant grant any object privilege to linder;
185

186

grant exempt access policy to linder;
187

grant exempt identity policy to linder;
188

189

grant alter resource cost to linder;
190

grant administer resource manager to linder;
191

192

grant sysdba to linder;
193

194

grant sysoper to linder;
195

196

grant audit any to linder;
197

198

grant analyze any to linder;
199

200

grant on commit refresh to linder;
201

202

grant resumable to linder;
203

204

grant advisor to linder;
205

206

grant execute any program to linder;
207

208

grant execute any class to linder;
209

210

grant manage scheduler to linder;
211

212

grant change notification to linder;
213

214

posted on 2011-02-11 17:20 Mr.wang 阅读(611) 评论(0) 编辑收藏引用所属分类: Oracle

只有注册用户登录后才能发表评论。


相关文章: 关于Oracle错误：动态执行表不可访问，本会话自动统计被禁止，关闭自动统计之后的问题 ORA-01950: 对表空间 'USERS' 无权限 oracle用户授所有权限在SQL*Pluse中以scott/tiger登录时提示ora-28000 the account is locked,解决办法

网站导航: 博客园 IT新闻 BlogJava 知识库博问管理

oracle用户授所有权限

导航

统计

常用链接

留言簿

随笔分类

随笔档案

搜索

最新评论

阅读排行榜

评论排行榜