Re: [ vuZs.net ] CS403 Answer Requested with Ref or supporting matieral

Question No: 29                     ( Marks: 1 )                - Please choose one

 GRANT SELECT, UPDATE(Designation) ON Employee TO Amali,Hiruni WITH GRANT

OPTION;

What does this SQL statement do?

  

► Grant permission to Amali,only to retrieve data from Employee table and grant permission to

Hiruni, only to update the designation from Employee table.

  ► Grant permission to Amali & Hiruni to retrieve data from Employee table.

  ► Grant permission to Hiruni in order to grant, select and update permission to Amali.

 ► Grant permission to Amali and Hiruni to update all data except designation in Employee

table

Hope this link will help u:

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_9013.htm

Ref:

Granting Object Privileges on a View: Example To grant SELECT and UPDATE privileges on the view emp_view, which was created in "Creating a View: Example", to all users, issue the following statement:

GRANT SELECT, UPDATE     ON emp_view TO PUBLIC;   

All users can subsequently query and update the view of employee details.

Mehreen Humayun

4th Semester, MBA(Banking)

Distance Learning Student

www.vuzs.net

Quality in Everything We Do

vuZs Banking Group: http://groups.google.com/group/vuzs_banking?hl=en

On Sat, Jun 25, 2011 at 9:50 AM, Zubair Hussain <zubair@vuzs.net> wrote:

What does this SQL statement do?

► Grant permission to Amali,only to retrieve data from Employee table and grant permission to

Hiruni, only to update the designation from Employee table.

► Grant permission to Amali & Hiruni to retrieve data from Employee table.

► Grant permission to Hiruni in order to grant, select and update permission to Amali.

► Grant permission to Amali and Hiruni to update all data except designation in Employee

table

Regards

Zubair Hussain

www.vuzs.net

--
--
Please visit www.vuzs.net For Current & Old Papers, Quizzes, Assignments and study material.
--
You received this message because you are subscribed to the Google
Groups "vuZs" group.
--
To post a new message on this group, send email to vuZs@googlegroups.com
--
Message Posting Rules: http://vuzs.net/faq/4795-vuzs-google-groups-basic-rules-for-posting-messages.html
--
To unsubscribe from this group, send email to vuZs+unsubscribe@googlegroups.com
--
To join this group Send blank email from your virtual university email address to
vuZs+subscribe@googlegroups.com
or visit
http://groups.google.com/group/vuZs/subscribe
---
For more information Contact vuZs Manager at info@vuzs.net

--
--
Please visit www.vuzs.net For Current & Old Papers, Quizzes, Assignments and study material.
--
You received this message because you are subscribed to the Google
Groups "vuZs" group.
--
To post a new message on this group, send email to vuZs@googlegroups.com
--
Message Posting Rules: http://vuzs.net/faq/4795-vuzs-google-groups-basic-rules-for-posting-messages.html
--
To unsubscribe from this group, send email to vuZs+unsubscribe@googlegroups.com
--
To join this group Send blank email from your virtual university email address to
vuZs+subscribe@googlegroups.com
or visit
http://groups.google.com/group/vuZs/subscribe
---
For more information Contact vuZs Manager at info@vuzs.net