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

  1. 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 ...

  2. 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 ...

  3. 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 : ...

  4. 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 ...

  5. 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 ...

  6. 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 ...

  7. 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 ...

  8. 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 ; // ...

  9. 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

  1. 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 . ...

  2. trade 1.0 Open source tools

    dapper.net T4PocoGenerator/ Dapper.ColumnMapper Reference link : http://blog.csdn.net/ymnets/article/details/85 ...

  3. 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 ...

  4. jQuery Realize sending verification code countdown 60 second

    front end HMTL: <div class="form_box"> <div class="line mb40"> <div class ...

  5. 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 : ...

  6. 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)

  7. 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 ...

  8. 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 ...

  9. 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 ...

  10. 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 $ ...