Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PLEASE HELP WITH THE ORACLE - SQL QUERY BELOW. (a) Write a command to enable your user on the class server to retrieve any data

PLEASE HELP WITH THE ORACLE - SQL QUERY BELOW.

image text in transcribed

(a) Write a command to enable your user on the class server to retrieve any data from a table named members that is owned by the idoe22 schema (b) Is this privilege a system level privilege or an object level privilege? (c) Write a command that requires this level of privilege on members. The members table structure is shown below EB MEMBERS Columns Data Constraints Grants Statistics ITriggers |Flashback Dependencies Details lPartitions Indexes ISQL ???? Actions COLUMN NAME 1 MEMBER ID 2 LAST NAME 3 FIRST NAME 4 ADDRESS 5 CITY 6 STATE 7 PHONE DATA TYPE NUMBER VARCHAR2(50 BYTE) VARCHAR2(50 BYTE) VARCHAR2(100 BYTE) VARCHAR2(30 BYTE) CHAR(2 BYTE) CHAR(12 BYTE) NULLABLE No No No Yes Yes Yes Yes DATA_DEFAULT (null) (null) (null) (null) (null) (null) (null)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intelligent Information And Database Systems Asian Conference Aciids 2012 Kaohsiung Taiwan March 2012 Proceedings Part 2 Lnai 7197

Authors: Jeng-Shyang Pan ,Shyi-Ming Chen ,Ngoc-Thanh Nguyen

2012th Edition

3642284892, 978-3642284892

More Books

Students also viewed these Databases questions