oracle用户授所有权限,oracle用户授所有权限

oracle用户授所有权限

1

grant

alter

system

to

linder;

2

grant

audit system

to

linder;

3

4

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

9

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

15

grant

create

user

to

linder;

16

grant

become

user

to

linder;

17

grant

alter

user

to

linder;

18

grant

drop

user

to

linder;

19

20

grant

create

rollback

segment

to

linder;

21

grant

alter

rollback

segment

to

linder;

22

grant

drop

rollback

segment

to

linder;

23

24

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

38

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

43

grant

create

any

index

to

linder;

44

grant

alter

any

index

to

linder;

45

grant

drop

any

index

to

linder;

46

47

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

53

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

63

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

69

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

77

78

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

83

grant

force

transaction

to

linder;

84

grant

force

any

transaction

to

linder;

85

grant

select

any

transaction

to

linder;

86

87

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

94

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

99

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