oracle查询基础4.ppt

[Title of the course] * Copyright ? 2004-2005 NameOfTheOrganization. All rights reserved. * The example on the slide creates a manager role and then enables managers to create tables and views. It then grants De Haan and Kochhar the role of managers. Now De Haan and Kochhar can create tables and views. If users have multiple roles granted to them, they receive all of the privileges associated with all of the roles. [Title of the course] * Copyright ? 2004-2005 NameOfTheOrganization. All rights reserved. * Confirming Granted Privileges If you attempt to perform an unauthorized operation, such as deleting a row from a table for which you do not have the DELETE privilege, the Oracle server does not permit the operation to take place. If you receive the Oracle server error message “table or view does not exist,” then you have done either of the following: ? Named a table or view that does not exist ? Attempted to perform an operation on a table or view for which you do not have the appropriate privilege You can access the data dictionary to view the privileges that you have. [Title of the course] * Copyright ? 2004-2005 NameOfTheOrganization. All rights reserved. * [Title of the course] * Copyright ? 2004-2005 NameOfTheOrganization. All rights reserved. * [Title of the course] * Copyright ? 2004-2005 NameOfTheOrganization. All rights reserved. * Use the For more slide to provide learners with suggestions on how to continue learning about the subject of this course. Add or remove elements as needed. If you add additional elements, such as images or text, remember to give each element a Fade or some other animation effect. Also consider referring learners to job-aids, online discussion forums, blogs, knowledge bases, help desks, Webinars, and other sources of knowledge. To make links open referenced Web sites: Select the text you want as a link. Select Insert ? Hyperlink or type Ctrl-K. Enter the Web address in the Address field. Click OK. [Title of the cou