CS352-LabExer001.pdf - NAME JUAN DELA CRUZ TITLE Manage role and apply privileges MACHINE ACTIVITY NO Lab Exercise 1 COURSE USN ID DATE Directions 1 2 3

CS352-LabExer001.pdf - NAME JUAN DELA CRUZ TITLE Manage...

This preview shows page 1 - 2 out of 4 pages.

NAME: JUAN DELA CRUZ COURSE: TITLE: Manage role and apply privileges USN ID: MACHINE ACTIVITY NO. Lab Exercise 1 DATE: 10-08-19 CS352-DBMS2-MAS Page 1 Directions : Perform the following activity Managing roles by applying different type of privileges. : Copy and paste the DEPARTMENTS table included in this activity. : In each number add the PL/SQL used. : Answer the questions ask in each number. : Skipping a number would cause different output consider as incorrect answer. 1. What privilege should a user be given to log on to the Oracle server? Is this a system or an object privilege? CREATE SESSION SYSTEM PRIVILEGE __________________________________________________________________ 2. What privilege should a user be given to create tables? CREATE TABLE PRIVILEGE _____________________________________________________________________ 3. If you create a table, who can pass along privileges to other users on your table? ANYONE YOU HAVE GIVEN THE PRIVILEGES TO BY USING THE WITH GRANT OPTION _____________________________________________________________________ 4. You are the DBA. You are creating many users who require the same system privileges. What should you use to make your job easier? Create a role containing the system privileges and grant the role to the users . _____________________________________________________________________ 5. What command do you use to change your password? The ALTER user statement _____________________________________________________________________ 6. Connect To iqlplus* using the following session: Username: SYTEM Password: oracle 7. Populate the given DEPARTMENTS table as shown below: Before proceedings to the next number make sure to double check you should have 8 rows of values .
Image of page 1

Subscribe to view the full document.

Image of page 2
  • Winter '18
  • mark sena

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Ask Expert Tutors You can ask 0 bonus questions You can ask 0 questions (0 expire soon) You can ask 0 questions (will expire )
Answers in as fast as 15 minutes