Home
Search results “Quota oracle user tablespace”
TABLESPACE MANAGEMENT GRANT REVOKE QUOTAS ON TABLESPACE FOR USERS
 
06:20
How to grant/revoke quota for Users on Tablespace ================================================= create tablespace test datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\test.dbf' size 10m;---(tablespace created) create user naveen identified by naveen;(user created) alter user naveen quota 2m on test;(granted 2m on test tablespace) alter user naveen quota unlimited on test;(granted unlimited on test) How to revoke unlimited tablespace from user ============================================= revoke unlimited tablespace from &user; How to check the views on quotas ================================= select table_name from dict where table_name like '%QUOTA%'; Queries for tablespace quotas on all users ========================================== set lines 180 set pages 200 col tablespace_name for a30 col username for a20 select * from user_ts_quotas; set lines 180 set pages 200 col tablespace_name for a30 col username for a20 select * from dba_ts_quotas;
Views: 474 Praveen Biyyapu
Oracle Database Users / User Management (Simple)
 
09:33
Create, Alter, Drop, Grant Rights, Default Tablespace, Temporary Tablespace, Quota Setup, View Users Information, Lock / Unlock user account select username,account_status,default_tablespace, temporary_tablespace,created from dba_users; create user myuser identified by myuser; alter user myuser quota unlimited on mytbs; alter user myuser quota 100m on mytbs; alter user temporary tablespace temp; alter user myuser default tablespace mytbs; alter user myuser accout unlock; alter user myuser account lock; alter user myuser password expire; alter user myuser identified by youuser; create user myuser identified by myuser default tablespace users temporary tablespace temp quota unlimited on users; grant create session, resource to myuser; grant create session, resource to myuser with grant option; drop user asif; drop user asif cascade;
Views: 40739 Abbasi Asif
How to create oracle 11g Table space (user schema creation)
 
11:02
create tablespace rfdemo logging datafile '/oradata/DB11G/rfdemo.dbf' size 5G autoextend on next 512m maxsize 10G extent management local; CREATE USER rfdemo IDENTIFIED BY rfdemo DEFAULT TABLESPACE rfdemo TEMPORARY TABLESPACE TEMP; GRANT "RESOURCE" to rfdemo; GRANT "CONNECT" to rfdemo; GRANT "DATAPUMP_EXP_FULL_DATABASE" to rfdemo; GRANT "DATAPUMP_IMP_FULL_DATABASE" to rfdemo; REVOKE UNLIMITED TABLESPACE FROM rfdemo; ALTER USER rfdemo QUOTA UNLIMITED ON rfdemo; commit;
Views: 7687 ab1 ek
What is tablespace quota in Oracle
 
01:59
What is tablespace quota in Oracle - Find out more explanation for : 'What is tablespace quota in Oracle' only from this channel. Information Source: google
Create new user in Oracle PL SQL
 
05:12
Create new user in Oracle PL SQL Oracle tutorial : How to Create New User in Oracle CREATE USER user_name IDENTIFIED BY password DEFAULT TABLESPACE tablespace_name QUOTA 20M on tablespace_name; Grant Create session Command to new user: GRANT CREATE SESSION TO user; How to Drop New User: DROP USER username CASCADE; #techquerypond https://techquerypond.wordpress.com https://techquerypond.com https://twitter.com/techquerypond
Views: 291 Tech Query Pond
ORACLE: USERS -Tạo USER và những quyền cơ bản.
 
10:21
[ORAVN.COM] USERS - Tạo USER và những quyền cơ bản. ------ Trả lời những câu hỏi: - Làm thế nào để tạo USER trên Oracle? - Thế nào là DEFAULT TABLESPACE ? - Những quyền tối thiểu nào để user có thể kết nối vào DB và tạo đối tượng cơ bản, vd: tables ? - Tạo sao phải cần QUOTA ? - ....
Views: 948 Database Tutorials
unlimited tablespace
 
03:21
Views: 16 Pablo Aguila
Oracle Default Tablespace.mp4
 
00:52
how to audit oracle database default tablespace assignment
Views: 296 checklist20
create user dbase management security
 
27:21
create user, identified by, default parmanent tablespace, temporary table space, quota, profile, dba_users,dba_ts_quota,dba_profile, USERS, TEMP, DEFAULT, SYSTEM TABLESPACE,sql, oracle 11g , database management security, security database
Views: 1236 Dr. Girija Narasimhan
12  Create Quota each User
 
09:14
Views: 1097 Choub Vutha
QUOTA UNLIMITED
 
00:48
Saya membuat video ini dengan Editor Video YouTube (http://www.youtube.com/editor)
Views: 2820 Queen Games57
Tips on Protection from Oracle TNS Poisoning Zero Day Vulnerability
 
36:47
Protect Your Oracle Databases from the Oracle TNS Poisoning. With Josh Shaul, CTO at Application Security. More info at http://www.appsecinc.com
Views: 1668 appsecinc
Simplified DBA-012-What is a SCHEMA in Oracle Database
 
02:32
Before you can create any table in database, you need access and resources in database. Access is allowed to a database user or schema. The term user and schema are used interchangeably. A schema is logical grouping of tables and other objects related to an application. Let say you have two different business applications. One application is used my manufacturing company that connect to database as MFG schema and other is a telecom application that connects to database as TEL schema. You will create two schemas as follows: CREATE USER MFG identified by oracle123 default tablespace users temporary tablespace temp; GRANT connect, resource to MFG; alter user MFG quota unlimited on USERS; CREATE USER TEL identified by oracle123 default tablespace users temporary tablespace temp; GRANT connect, resource to TEL; alter user TEL quota unlimited on USERS; alter user MFG quota unlimited on USERS Connect mfg/oracle123 Create table mfg_data(sno number(1) primary key, sname varchar2(20); Connect tel/oracle123 Create table tel_data(sno number(1) primary key, sname varchar2(20);
Managing User Resources   Quotas and Permissions
 
26:27
Managing User Resources Quotas and Permissions
Views: 135 NaturalSnaps
Disk quota
 
01:12
Disk quotas are typically implemented on a per-user or per-group basis. That is, a system administrator defines a usage or file quota specific to a certain user or group.
Views: 59 Amit Goyal
How to implement VPD in Oracle Database (Part 1)
 
12:37
How to implement VPD (Virtual Private Database) in Oracle Database(9i,10g,11g,12c) Enterprise Edition. PART 1 Video links: Part 1 https://youtu.be/JVvtvh3cN1I Part 2 https://youtu.be/xLcin_Wgbvs Part 3 https://youtu.be/mE1cSbmEwnQ This is Part of Oracle Advance Security. Please view my earlier videos on how to create a database , if you are not having a database. 1)First we will create the users needed for our environment a)Owner of the schema which will have the objects or tables b)security admin user c)non owner user1 & user2 which will have limited access as per data in the rows (here user1 will have access to data with HR and user2 with FINANCE) Object owner creation: -------------- CREATE USER schemaowner IDENTIFIED BY schemaowner DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp; GRANT connect, resource TO schemaowner; alter user schemaowner quota unlimited on users; security admin user creation: -------------- CREATE USER SEC_ADM IDENTIFIED BY sec_adm default tablespace users temporary tablespace TEMP; GRANT CONNECT, RESOURCE TO sec_adm; alter user sec_adm quota unlimited on users; garnts for the sec_adm user: ------------- GRANT CREATE SESSION,CREATE ANY CONTEXT,CREATE PROCEDURE,CREATE TRIGGER, ADMINISTER DATABASE TRIGGER TO SEC_ADM; GRANT EXECUTE ON DBMS_SESSION TO SEC_ADM; GRANT EXECUTE ON DBMS_RLS TO SEC_ADM; create user with restricted access on table: ----------------------- CREATE USER user1 IDENTIFIED BY user1 DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp; GRANT connect, resource TO user1; CREATE USER user2 IDENTIFIED BY user2 DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp; GRANT connect, resource TO user2; Now we will log in as schemaowner and create one tables : ------------------- CONN schemaowner/schemaowner This table is the table which contains the secure as well as un-restricted data CREATE TABLE user_data (column1 VARCHAR2(50) NOT NULL, user_id VARCHAR2(30) NOT NULL); Now to access this table from other schema we need to give the select and insert privs to: GRANT SELECT, INSERT ON user_data TO sec_adm,user1, user2;
Views: 740 OracleDBA
How to Create an user in Oracle
 
14:49
How to Create an user in Oracle with minimum grants/privileges we need to connect as SYSDBA lets ceate an user test you can see the user is created : But can it connect? lets open a new session we can see it lacks create session priv. so, we grant the create session privilege to user test lets test Its connecting. But is it able to create a table ,lets check. it lacks the ability to create table. SO lets give the privilege. lets test again the create table command. its throwing error regarding no Privilege on users tablespace . But we have given USERS as the default tablespace to test(user). So whats the problem? The problem is there is not quota defined for user test. lets give some quota like "10MB" or UNLIMITED , we will giev 10MB NOw let us test. So we can see that we now have sufficient / minimum privileges for the user test. Hope this will help in understanding the concept behind user creation
Views: 97 OracleDBA
Créer Tablespace est Fichier de données
 
03:01
tablespace tablespace in oracle tablespace does not exist tablespace size in oracle tablespace usage in oracle tablespace is missing for table tablespace postgres tablespace encryption tablespace free space tablespace in db2 alter tablespace add datafile tablespace in oracle oracle tablespace management drop tablespace including contents ora-01950: no privileges on tablespace users grant unlimited tablespace to user create tablespace example create tablespace oracle ora-25153: temporary tablespace is empty drop tablespace oracle tablespace in oracle tablespace management in oracle 11g tablespace in db2 tablespace management tablespace encryption in oracle 11gr2 tablespace pgadmin tablespace in sql developer tablespace in oracle tutorial tablespace postgres tablespace point in time recovery step by step what is a tablespace how do you create a oracle tablespace how do you monitor the tablespace is 80 percent fu what is the difference between tablespace and a ta why do you take tablespace in backup mode when a user creates an object without a tablespace what is the minimum size for dictionary managed ta the data file belonging to the system tablespace i in db2 is there any way of checking to see what th tablespace tablespace usage tablespace oracle tablespace users tablespace size tablespace full tablespace fragmentation tablespace management tablespace definition tablespace report tablespace quota tablespace growth tablespace sysaux
Views: 103 INFO TECH
Creating & Dropping User when DB is in Connected Mode using SQL Command
 
13:04
STEPS:- 1. open command prompt 2. login into sqlplus with user: sqlplus sys/password as sysdba 3. create a user using sql command SYNTAX: CREATE USER username IDENTIFIED BY paswword DEFAULT TABLESPACE tablespacename TEMPORARY TABLESPACE tablespacename QUOTA 5M ON USER ACCOUNT lock/unlock; or CREATE USER username IDENTIFIED BY paswword 4. give system privileges GRANT CREATE SESSION, CREATE TABLE TO username; 5. login to user using SQL developer and sqlplus now login into sys user in sql developer 6. droping user which is connected to database follow the step - login into sys user with admin mode - ALTER SYSTEM ENABLE RESTRICTED SESSION - SELECT sid,serial# FROM V$SESSION WHERE username='clerk'; (OR) SELECT * FROM V$SESSION; - ALTER SYSTEM KILL SESSION 'sidno','serial#no'; - DROP USER username CASCADE; we cant find the user because the user clerk is dropped. Thank you for watching Blog:- http://ramprasath91.blogspot.com Facebook:- https://www.facebook.com/Ramprasath.tamil LinkeIn:- https://in.linkedin.com/pub/ramprasath-d/80/3b0/a22
Views: 606 TechWizard
DEMO | Oracle Source Volume Rollback
 
05:45
InMage Scout can rollback the source volume for Oracle
Views: 46 InMageRecovery
Table size ,Number of records,Disk usage in SQL Database,clear logs,cache
 
06:51
This clip will show you how to check each Table size, Number of records, Disk usage in SQL Database. You can see how to write the query to get details of all tables in terms of size, records, space utilization and free space on disk for tables. http://daynamicsaxaptatutorials.blogspot.com This is axapta ERP blog for Technical and functional fields and includes Microsoft Dynamics Axapta tutorials and Dynamics Axapta Coverage. This blog also contains x++ code help for Ax developer and solution of technical and functional daily issues. This blog is specific for Microsoft dynamics programming. Enterprise portal, SharePoint services, business connectors and Enterprise Resource Planning applications and sql database.It will help to get Microsoft Business Solutions.
Views: 701 Santosh kumar Singh
03 Installing Oracle 11G Express Edition and Schema Creation
 
09:37
In this video we are going to see how to install Oracle 11G Express Edition, Schema creation and use with IBM Sterling Order Management System Link : http://activekite.com Register : http://activekite.com/wp-login.php?action=register Welcome to ActiveKite.com Google Search String : oracle 11g express edition free download Download Link : http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html ----------------------------------- Create Schema ----------------------------------- create user sterling94 identified by sterling94; --grant privileges: grant create session, alter session, create any sequence, alter any sequence, create procedure, create synonym to sterling94; grant create table, create trigger, create type, create view, delete any table, execute any procedure, execute any type to sterling94; grant connect, insert any table, select any dictionary, select any sequence, update any table to sterling94; grant select_catalog_role to sterling94; create bigfile tablespace sterts_01 datafile 'sterts_f1.dat' size 100M autoextend on; alter user sterling94 default tablespace sterts_01 quota unlimited on sterts_01;
Views: 275 ActiveKite
Manage Oracle Tablespaces with Oracle Enterprise Manager 12C
 
03:37
Video tutorials on how Manage Oracle Tablespaces using Oracle Enterprise Manager 12C For more Database Administration articles and scripts go to www.aodba.com More Articles, Scripts and How-To Papers on http://www.aodba.com
Views: 6679 AO DBA
SQL Training 4
 
28:51
DCL, Create user, Tablespace, Assign Priviliges, DBA Work By: naktakas
USER,ROLES,PROFILES
 
01:14:54
USER/ROLES/PROFILES/PRIVILEGES/
Views: 646 Sainora Annanagar
SQL tutorial 45: Introduction to user Privileges in Oracle Database By Manish Sharma RebellionRider
 
04:30
First SQL Tutorial in the series of user privileges in oracle database an introduction to user privileges. In this tutorial you will learn ● What is user privileges ● Different types of user Privileges ● Data Control Language (DCL) Grant and Revoke ● Who Can Grant or Revoke System Privileges? ● Oracle grant flags such as "With Admin option, With Grant option and with hierarchy option " This is a quick video on Introduction of user privileges expaining the theoretical concepts for the better understanding of the concept and up coming videos in USER PRIVILEGE series. Celebrating 1000 subscribers. Thanks a lot guys for all your love and support. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/introduction-to-user-privileges ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the first one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at [email protected] Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 26768 Manish Sharma
Finding Performance Tuning In Oracle
 
00:50
http://www.perftuning.com - If you need performance tuning in Oracle, you need to find reliable service providers to work with. There are several Oracle performance tuning services these days and all of them provide reliable Oracle database tuning you need. However, before you agree to get Oracle performance tuning ppt presentations, consider whether or not the service providers are recommended by previous clients.
Views: 28 Francesca Lytle
SQL tutorial 38: How to create user using SQL Developer in Oracle database
 
06:52
How to create new user accounts using SQL Developer in oracle database. In This tutorial you will learn how to create a new user account. How to setup a database connection with SyS user. How to grant privileges to the user ----_Links_--- Blog :http://bit.ly/create_user_account Video Tut 4: http://youtu.be/wSqoXRlXDUU How to create database: http://youtu.be/enFFezPYhCg Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 Amazon Wishlist: http://bit.ly/wishlist-amazon Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com
Views: 61359 Manish Sharma
Oracle 11g Database Istanbul Lansmanı
 
02:34
Oracle 11g Database Istanbul Lansmanı
Views: 127 Ozgur SARIGUL
SQL tutorial 39: How to create user in oracle using Enterprise Manager
 
07:44
3rd and the last tutorial on how to create user in oracle database 11g or 10g. Enterprise manager is a web-based tool for managing databases created on the system. _____Links____ Website: http://www.RebellionRider.com Amazon Wishlist: http://bit.ly/wishlist-amazon Tutorial 37 create user using SQL Create User statement http://youtu.be/4QbK2Y-1LZw Tutorial 38 create user using SQL Developer too http://youtu.be/GS4udgR44Ls Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com
Views: 25412 Manish Sharma
crear usuarios y asigarles privilegios( Oracle 11g )
 
04:08
create user identified by "" default tablespace USERS temporary tablespace TEMP profile DEFAULT quota 3m on users; grant create procedure to ; grant create sequence to ; grant create session to ; grant create synonym to ; grant create table to ; grant create view to ;
Views: 8008 Fernando Boza Gutarra
Oracle SQL Developer Tutorial For Beginners   29   DBA Info   MetaData
 
01:12
Oracle SQL Developer Tutorial For Beginners Series. This course introduces Oracle SQL Development for its subscribers. Currently this is based on Oracle 12c. The test environment is in Windows 10.
Views: 1519 Sam Dhanasekaran
Oracle's Database as a Service in action
 
15:44
Preview Lecture of Udemy Course: Oracle Private Database Cloud ===================================================== In this lecture I will demonstrate Oracle's Database as a Service in action, via the Oracle Enterprise Manager self service console and logged in as the self-service user. We will create a single instance database via self-service. For the complete Udemy course, please visit https://www.udemy.com/oracle-private-database-cloud/?couponCode=ORANOVTODEC16 Course Description =============== This course will introduce you to the concepts of the Oracle Private Database cloud. You will be taught techniques for building, configuring, and managing a private database cloud with Oracle Enterprise Manager 13c Cloud Control. Learn best practices for a wide variety of different approaches--Database as a Service, Snap Clone as a Service, Schema as a Service, and Pluggable Database as a Service. The course also explains how to use the Oracle Cloud REST API for performing Database as a Service. You will gain a reasonable understanding of how to architect, configure, and manage every component in a private database cloud lifecycle. Learn from an Oracle Certified Master, previous Oracle ACE Director, and experienced computing writer (three books published on Oracle Enterprise Manager). What are the requirements? Oracle Enterprise Manager Cloud Control 13c installed on a sandbox server - Enterprise Manager Cloud Control is the main driving engine for the Oracle private database cloud Oracle Database Enteprise Edition Homes installed for 11g and 12c Oracle Databases created - 11g for SChaaS and 12c container database for PDBaaS Alternatively, you can follow the lectures without an actual install of the software What am I going to get from this course? Understand the concepts and requirements of the Oracle Private Database Cloud Learn techniques and best practices for building, configuring, and managing a private database cloud with Oracle Enterprise Manager 13c Cloud Control Set up the foundation of the Oracle Private Database Cloud - including the Enterprise Manager Software Library, Enterprise Manager Self update, User Privileges and Roles for self-service, and the PaaS Infrastructure Zones Set up and Configure Database as a Service and Snap Clone as a Service - Database Pools, Quotas, Database Profiles, Database sizes, Service Templates, Request Settings See Database as a Service in action using the Enterprise Manager Self-Service console See Snap Clone as a Service in action using the Enterprise Manager Self-Service console Set up and Configure Schema as a Service - Schema Pools, Quotas, Schema Profiles, Service Templates, Request Settings See Schema as a Service in action using the Enterprise Manager Self-Service console Set up and Configure PDB as a Service - PDB Pools, Quotas, PDB Profiles, Service Templates, Request Settings See PDB as a Service in action using the Enterprise Manager Self-Service console Understand how to use the Cloud REST API for performing Database as a Service, using the REST client in Google Chrome, and why you would use the Cloud REST API instead of the Enterprise Manager Self Service Console Understand the next course of action and further reading material What is the target audience? Students who want to get a basic understanding of the setup, configuration and actual use of the capabilities of the Oracle Private Database Cloud Students who want to understand the use of Oracle Enterprise Manager for Database as a Service, Snap clone as a Service, Schema as a Service and PDB as a Service Students who want to use the Cloud REST API for self-service in their own customized orchestration engine Students should have a basic understanding of Oracle Database install/administration concepts, and Oracle Enterprise Manager adminstrator concepts I hope this course is beneficial to you and your careers. All the Best. Great endorsement from my ex-colleague friend Bob Lofblad. Thanks Bob. "I used to work with Porus at Oracle and learned a lot from his workshops. This course is an amazing value for getting up to speed on using Enterprise Manager and the Cloud." - Bob Lofblad (Customer Success Manager - Public Cloud at Oracle) From my friend Rob Zoeteweij : "Just did the training course Oracle Private Database Cloud on Udemy by Porus Homi Havewala and I must say; this guy knows what he is talking about! If you are as eager I was to start working with DBaaS , Snap cloning, Schema as a Service and PDB as a Service using EM13c, this course really give you a head start. It takes you about 3 hours to follow and must say the course is pretty easy to follow and for its price, you get you value for your money. I really recommend this course. Good job Porus!" Thanks a lot, Rob. Really appreciated. Regards, Porus Homi Havewala (OCM). For the complete Udemy course, please visit https://www.udemy.com/oracle-private-database-cloud/?couponCode=ORANOVTODEC16
Views: 1432 Porus Homi Havewala
Oracle DBA Lite: an introduction to Oracle administration, part 4
 
14:55
CAPTIONS AVAILABLE - User management in Oracle
Views: 8463 roughsealtd
SQL tutorial 37: How to create NEW USER account using Create User statement in Oracle database
 
07:39
How to create new user accounts using Create User statement in oracle database. In This tutorial you will learn how to create a new user account. Brief explanation of Create user statement syntax and an example of creating a new user and You will learn How to grant Create session system privilege to your ----_Links_--- Blog :http://bit.ly/create_user_account Video Tut 4: http://youtu.be/wSqoXRlXDUU How to create database: http://youtu.be/enFFezPYhCg Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 Amazon Wishlist: http://bit.ly/wishlist-amazon Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com
Views: 39505 Manish Sharma
ORACLE: Aprenda a crear Tablespace, usuario y contraseña, conexion y sus respectivos privilegios
 
15:57
ORACLE: Aprenda a crear Tablespace, usuario y contraseña, conexion y sus respectivos privilegios. Le enseño 2 maneras de hacerlo, aun que hay varias forma se hacer
Views: 15664 Carlos Alva Suarez
CREATE ROLE DAN USER DI ORACLE
 
21:47
NADIA AYU SAVITRI - 2110167060 - D4LJPJJ TI 2016 Praktek membuat role 1. Buat role dengan nama nickname anda: 2. Berikan hak akses system privileges : Create session, create table Praktek membuat user di DB Oracle: 1. Buatlah nama user, nickname anda 2. Isikan profile default, default tablespace (yang telah dibuat sebelumnya) 3. Berikan hak akses role nikcname anda 4. Jangan lupa berikan kuota tablespace (yang telah dibuat sebelumnya) Ukuran quota terserah anda 5. Berikan object priviledge select ke schema hr pada table employees 6. Coba login dengan menggunakan user yang anda buat menggunakan SQLPLUS 7. Buatlah table, terserah anda nama table dan strukturnya 8. Coba select dan delete pada table employees di user hr
Views: 16 Nadia Ayu Savitri
CONEXION Y CREACION DE TABLAS EN SQLDEVELOPER
 
14:04
Código para crear el usuario create user DBSISTEMAS identified by "12345" default tablespace USERS TEMPORARY TABLESPACE TEMP PROFILE DEFAULT QUOTA 3M ON USERS; grant create procedure to DBSISTEMAS; grant create sequence to DBSISTEMAS; grant create session to DBSISTEMAS; grant create synonym to DBSISTEMAS; grant create TABLE TO DBSISTEMAS; grant create view to DBSISTEMAS;
Views: 30 Jorge_Luis LDU
Oracle Database 12c: Creating a User using Oracle Enterprise Manager Database Express
 
07:02
Demo of how to create a user with EM Express.
Views: 36429 OracleDBVision
How to install oracle 10g in windows
 
09:08
A Tutorial about how to install Oracle 10g in windows
Views: 27 Hariharan sekaran
Oracle Inventory Management Online Training
 
01:16
Oracle inventory management Online Training is Offering at Glory IT Technologies. We have Certified Working Professionals on this Modules. They trained so many Global Students, We also Provides Corporate Training, Job/Project Support Services to Oracle Inventory management. We are Only Institute Delivering Best Online Training Services to this Module.
Views: 45 Sirisha Glory
Atelier Géstion des utilisateurs et privileges(réponses dans description)
 
13:35
Correction: 1)-desc dba_users -select USERNAME from dba_users; 2)-create user Rami identified by ok default tablespace users; 3)-select USERNAME,ACCOUNT_STATUS,PROFILE from dba_users where username='RAMI'; 4)-conn Rami/ok // pas de privilege de connexion 5)-grant create session to Rami; 6)-alter user rami identified by merci; 7)-grant create table to rami; 8)-create table employe (code number(4),nom varchar2(10)); il a le problem de quota sur tablespace users; -alter user rami quota 10m on users; 9)-select bytes from user_segments where segment_name='EMPLOYE'; 10)-insert into employe values (&code,'&nom'); 11)-create user siri identified by ok default tablespace users quota 10m on users; -grant create session to siri ; 12)-select * from rami.employe; -grant select on rami.employe to siri; 13) drop user rami cascade;
Views: 18 Houssine Formation
Oracle Database Administration Online Training
 
04:21
Feel free to contact Call : +91-8870903864 Or E-mail [email protected] Oracle Database Adminstration INTRODUCTION TO ORACLE DBA What is DBA ? • Why a Company needs a DBA? • Roles & Responsibilities of DBA • Oracle Architecture • Physical and Logical Phase of Database • Types of files(Control file, Redolog file and Datafile) • Different types of Datafiles • Instance • SGA(System Global Area) and Background Process • DATABASE CREATION • Different Startup Modes • Different Shutdown Modes • Types of Database Creation • Manual Method of Creation • TABLESPACE MANAGEMENT Introduction to Table space • Types of Table space(BIG & SMALL) • Temporary Table space • Altering/Renaming a Table space • Renaming a data file • Temporary Groups • Table space Encryption(11g) • STORAGE PARAMETERS • What are segments? • What are extents? • What is Blocks? • Oracle Blocks • Estimation of Extents • Dictionary Managed Table space • Locally Managed Table space • Storage Parameters(Initial, Next, Min Extents, Xtents, Pctincrease) • USER MANAGEMENT • Who are Database Users? • Why to create a User? • Creation of Users • Assigning Privileges • Creating and granting Roles • Allocating table space Quotas to Users • Assigning default table space for the Users • Setting Profiles for the Users • Levels of Authentication • Schema Management(11g) • Security(11g) • UNDO MANAGEMENT • What is Undo? • Why Undo required? • Pending offline status • Brief idea about Rollback segments • Flashback Features • Flashback Table • Flashback query • Flashback Version query • What is spfile? • Difference between spfile and pfile • Advantages of spfile • What is OMF? • Advantages of OMF • Files conventions of OMF • NETWORKING IN ORACLE • Introduction to Oracle Networking • Network default location • Editing Network file • Tnsnames.ora Introduction to Database Links • Types of Database Links • Introduction to Materialized views • Advantages of Materialized view • Refresh Modes • REDO-LOG & CONTROLFILE MANAGEMENT Introduction to Redo log • Status of Redo logs • Multiplexing the Redo log files • Re-creation of Control file • Renaming the Database • Multiplexing the Control file • LOGICAL BACKUP What is a logical backup • Why it is required • Export/import Utility • Data Pump • Difference between Data Pump and Traditional Export/import • Impdp/expdp • Transportable Table spaces • PHYSICAL BACKUP Introduction to Physical backup • Types of Physical backup • Cold & Hot backup • Recovery scenarios • RMAN backup • RMAN Point in time recovery • RMAN 11g new features • PEFORMANCE TUNING What is Performance Tuning? • Why Tuning required? • Types of Tuning • Database Tuning • Tuning • SQL Tuning • Memory Tuning Network Tuning • Partitioning and Indexes • Partitioning Enhancements • AWR/ASH/ASMM/ADDM • RAT(Real Application Testing)(11g) • SQL Performance Analyses (11g) • Row chaining and Row migration • Resemble Table spaces Oracle Database Adminstration training online, Oracle Database Adminstration training material, IBM Websphere Application Server training cost, Oracle Database Adminstration training pdf, Websphere Application Server training in USA uae India, Oracle Database Adminstration training, online Corporate training malaysia Singapore, Oracle Database Adminstration software, Oracle Database Adminstration training in bangalore, Oracle Database Adminstration training institutes in hyderabad, Oracle Database Adminstration training in chennai, Oracle Database Adminstration training in hyderabad, Delhi, Mumbai, Pune, Oracle Database Adminstration, IBM Websphere ApplicationServer webinar, online training singapore, Oracle Database Adminstration eam, Oracle Database Adminstration as a service,Oracle Database Adminstration online Training Oracle Database Adminstration online Training Oracle Database Adminstration online Training Oracle Database Adminstration online Training maximo scheduler, Oracle Database Adminstration (consumer product) Oracle Database Adminstration online Training Oracle Database Adminstration online Training Oracle Database Adminstration online Training Oracle Database Adminstration online Training Oracle Database Adminstration online Training , Post Training Support
Views: 9 Trainers Online
Oracle Data Storage
 
09:58
CAPTIONS AVAILABLE - Full transcript (with some screenshots) available for a small fee at http://stores.lulu.com/konagora/. How Oracle stores your tables, how they grow, and how they can go bump.
Views: 8188 roughsealtd
alphorm.com | Tuto Lync Server 2010  70-664 (6/50) Le déploiement de Lync Server 2010
 
04:35
Cette vidéo/tutorial fait partie de la Formation Lync Server 2010 (70-664). Elle est réalisée par l'expert collaboration Windows Patrick Raujol pour http://www.alphorm.com. Vous pouvez retrouver toute la formation ici http://www.alphorm.com/formation/formation-configuration-microsoft-lync-server-2010-70-664 Voici le plan de cette vidéo/tutorial : L'outil Microsoft Planning Tools for Lync Server 2010 La hiérarchie des stratégies Lync Server 2010 La préparation d'Active Directory Le processus de déploiement d'une architecture Le déploiement d'un pool Frond End Le déploiement des autres rôles Bonne formation.
Views: 96 alphorm.com
alphorm.com | Formation Lync Server 2010  70-664 (15/50) Présentation de la messagerie unifiée
 
03:17
Cette vidéo/tutorial fait partie de la Formation Lync Server 2010 (70-664). Elle est réalisée par l'expert collaboration Windows Patrick Raujol pour http://www.alphorm.com. Vous pouvez retrouver toute la formation ici http://www.alphorm.com/formation/formation-configuration-microsoft-lync-server-2010-70-664 Voici le plan de cette vidéo/tutorial : Qu'est ce que la messagerie unifiée L'architecture de messagerie unifiée Bonne formation.
Views: 48 alphorm.com
Practica 1 Seguridad en bases de datos
 
04:03
1. Ataque por inyección de código SQL.
Views: 46 Daniel Beltran

Cover letter for medical sales role
No paper writing service
Looking for a new career cover letter
Paralegal cover letter tips
Writing dissertation service