FazBrowse GitHub Viewer
|
Trending
|
URL:
|
Home
Tools:
[Download Repo ZIP]
[View Raw Code]
[Original HTTPS Page]
utPLSQL/source/create_utplsql_owner.sql at develop · Emanuel3003/utPLSQL · GitHub
Emanuel3003
/
utPLSQL
Public
forked from
utPLSQL/utPLSQL
Notifications
You must be signed in to change notification settings
Fork
0
Star
0
Code
Pull requests
0
Actions
Projects
Wiki
Security and quality
0
Insights
Additional navigation options
Code
Pull requests
Actions
Projects
Wiki
Security and quality
Insights
Expand file tree
Breadcrumbs
utPLSQL
/
source
/
create_utplsql_owner.sql
Copy path
More file actions
More file actions
Latest commit
History
History
History
35 lines (26 loc) · 1.14 KB
Breadcrumbs
utPLSQL
/
source
/
create_utplsql_owner.sql
Copy path
File metadata and controls
35 lines (26 loc) · 1.14 KB
Raw
Copy raw file
Download raw file
Open symbols panel
Edit and raw actions
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
/*
utPLSQL - Version X.X.X.X
Copyright 2016 - 2017 utPLSQL Project
Licensed under the Apache License, Version 2.0 (the "License"):
you may not use this file except in compliance with the License.
You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
*/
whenever sqlerror exit failure
rollback
whenever oserror exit failure
rollback
set
echo off
set
feedback off
set
heading off
set
verify off
define ut3_user
=
&
1
define ut3_password
=
&
2
define ut3_tablespace
=
&
3
create user &ut3_user identified by &ut3_password default tablespace &ut3_tablespace quota unlimited
on
&ut3_tablespace;
grant
create session, create sequence, create procedure, create type, create table, create view, create synonym to &ut3_user;
grant
execute
on
dbms_lock to &ut3_user;
grant
alter session to &ut3_user;
Back
|
FazBrowse Home
|
New Git URL