Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
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;
(Two users)
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.
A use case diagram giving a pictorial overview of user requirements and brief use case descriptions. As the case study contains only an outline of a business scenario, you will als
Give the levels of data abstraction? There are three levels of Data Abstraction a) Physical level b) logical level c) view level
Accessing information about permissions to all users- Object level permissions: With the use of data dictionary you can see the permissions to user. Let us get the table name fro
What is called block-level striping? Block level striping stripes blocks across many disks. It treats the array of disks as a large disk, and provides blocks logical numbers
comparison of oracle RDBMS with MySQL
What is an object ID? Each class-derived table has an ID for primary key, one or more object IDs form primary key for association derived tables. An object ID is equivalent dat
One-way Associations When an association is traversed only in the one direction, then it is implemented as a pointer i.e.an attribute which contains an object reference. If mu
You are required to design and build a data mart/data warehouse using Oracle. A national bank allocates funding every year for its local branches to provide temporary staff cove
various techniques of hashing?
Define entity integrity and referential integrity. How does SQL allow specification of these? Ans: Entity Integrity Rule- If the attribute A of relation R is a prime attribut
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!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd