Already have an account? Get multiple benefits of using own account!
Login in your account..!
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Example-GRANT CREATE SESSION TO MCA12;
(This command gives system level permission on creating a session - not portable)
GRANT SELECT ON EMP TO MCA12;
(Object level permission on table EMP)
GRANT SELECT, UPDATE, INSERT, DELETE ON EMP TO MCA12;
GRANT SELECT, UPDATE ON EMP TO MCA12, MCA13;
GRANT ALL ON EMP TO PUBLIC;
(All permission to every users, do not use it. It is very risky for database)
Revoke: It is used to revoke the permission granted.
What is a SELECT operation? The select operation selects tuples that please a given predicate. We use the lowercase letter σ to denote selection.
Assume that you are responsible for selecting a new DBMS product for Sohar Hospital
Write a short note on QBE? Stands for "Query By Example." QBE is a feature involved along with various database applications which gives user-friendly techniques of running da
Which model is record based logical model? Network Modelis basically known as record based logical model.
What is Oracle databse structure? Oracle database structure: The relational model has three main aspects: Structures: Structures are well-defined objects which store th
What are the benefits of decomposing a system? The benefits of decomposing a system into subsystems are that after decomposition, each individual component become smaller and e
what is the importance of back up files
How to create a biological database based on viruses. How to decide which attribute should be there in the table and schema? How to identify the primary keys, foreign keys, domain,
What is Identity? Identity (or AutoNumber) is a column that automatically produces numeric values. A start and increment value can be set, but most DBA leave these at 1. A GUID
Advantages and disadvantages of icloud based storage
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd