With sysdba land
Create user :CREATE USER username IDENTIFIED BY password;
grant ( role ) jurisdiction :GRANT CONNECT,RESOURCE TO username;
notes :oracle There are three types of standard roles :CONNECT,RESOURCE,DBA
Of course, users themselves ( As long as you have permission ), You can create your own roles and give them corresponding permissions .
Oracle Create users and authorize more related articles
- oracle Create user , Authorized user , Create table , Query table
original text :oracle Create user , Authorized user , Create table , Query table oracle Create user , Authorized user , Create table , Query table hypothesis oracle10g All have been installed and configured First step :win+R, Go into operation ,cmd; The second step ...
- Oracle Create user 、 to grant authorization 、 The rules
--- User login command -- Administrator login conn sys/oracle as sysdba;-- Creating user schemes must be administrator privilege -- Create user commands create user useranme identifild b ...
- oracle Create user 、 to grant authorization 、 Import 、 Export command summary
1. Create user We need to use it first. system User login database , because system Users have the right to create other users . grammar [ Create user ]: create user user name identified by password [ The code ]: Example : ...
- Oracle Create a user and give the user permission to query a specified table or view
MSV31 Log in to the database and perform the following operations : CREATE USER NORTHBOUND IDENTIFIED BY NORTHBOUND DEFAULT TABLESPACE "TBS_DN ...
- oracle Create tablespace 、 Create user 、 Authorizing roles and importing and exporting user data
Log in as a database administrator -- log as sysdba sqlplus / as sysdba; Create a temporary table space -- create temporary tablespace create tem ...
- Oracle Learning notes _05_ Create a table space 、 Create user 、 The whole process of Authorization
One . Full command su - oracle sqlplus /nolog conn /as sysdba create tablespace scaninvoice logging datafile '/u ...
- oracle The database creates users and authorizes
oracle The database creates users and authorizes remarks : userName Username ,123456 Is password drop user userName cascade; create user userName iden ...
- Detailed explanation Oracle The whole process of creating user rights
This article is about creating a table , To realize Oracle The process of creating user rights . The following code is mainly for the realization of Oracle Create user rights and write , I hope it can help you . Be careful : Each language is executed separately , You have to end with a semicolon ; // ...
- oracle11g Create users and authorize
Oracle Create a user and give the user permission to query the specified table or view sys Log in to the database and perform the following operations : CREATE USER NORTHBOUND IDENTIFIED BY NORTHBOUND DEFAUL ...
Random recommendation
- iOS and Android Basic date processing in
When it comes to date processing , There are mainly 2 Parameters , One is the time zone , One is the calendar method used . Mainly involves 2 Big problems , One is the conversion between date type and string , The other is the calculation of date .ios and android All of them provide corresponding classes to deal with problems . ...
- trade 1.0 Open source tools
dapper.net T4PocoGenerator/ Dapper.ColumnMapper Reference link : http://blog.csdn.net/ymnets/article/details/85 ...
- Fragment Lazy loading
When we do application development , One Activity It might be in the form of viewpager( Or other containers ) With many Fragment To combine , And if each fragment You need to load data , Or load from local , Or load from the network , So in ...
- jQuery Realize sending verification code countdown 60 second
front end HMTL: <div class="form_box"> <div class="line mb40"> <div class ...
- jq towards webApi Submit post json data
Thinking on the page webApi post json Data time , Find out webapi You can't just json Accept data in a different way ( notes : I didn't find a good way to post json Data ); But it can be delivered as a data structure : as follows : ...
- RabbitMQ Series catalog
1.RabbitMQ install and configure ( High availability clusters and delay queues ) 2.AMQP Protocol is introduced 3.RabbitMQ Client side usage (EasyNetQ)
- Linux(CentOS7) Command learning summary
1. Change the machine name hostnamectl set-hostname newname 2. hosts Host storage location /etc/hosts 3. install tigervncserver, And then use vncserv ...
- 20165231 2017-2018-2 《Java Programming 》 The first 2 Weekly learning summary
Preface The second week is a formal study java Programming . Previous pair java It's a blank , Now it's the first sign , got it java The basic beginning of the program , Multiple class Which one to run when , Which is the output print statement and so on . Currently I use java ...
- jQuery Lazy loading plug-ins – jquery.lazyload.js Simple call
Lazy Load It's a use. JavaScript Compiling jQuery plug-in unit . It can delay loading images in long pages . Images outside the browser's viewable area will not be loaded , Until the user scrolls the page to where they are . This is related to the picture pre ...
- Gym 101873K - You Are Fired - [ Greedy for water ]
Topic link :http://codeforces.com/gym/101873/problem/K The question : Now give $n(1 \le n \le 1e4)$ Employees , The most you can do is lay off $k$ people , The name is $ ...