Oracle Magazine, Nov/Dec 2017
Database Application Developer and DBA BEYOND SQL 101 ORACLE MAGAZINE NOVEMBER DECEMBER 2017 104 GRANTEE PRIVILEGE CONNECT CREATE SESSION CONNECT SET CONTAINER RESOURCE CREATE CLUSTER RESOURCE CREATE INDEXTYPE RESOURCE CREATE OPERATOR RESOURCE CREATE PROCEDURE RESOURCE CREATE SEQUENCE RESOURCE CREATE TABLE RESOURCE CREATE TRIGGER RESOURCE CREATE TYPE When you executed the above statement because the SQL_ 201 user was granted the CONNECT and RESOURCE roles the user received the ability to perform many of the actions it has performed in this seriess articles including CREATE SESSION CREATE TABLE and CREATE SEQUENCE Listing 13 demonstrates how to revoke a granted privilege from a user This command can also be used to revoke a privilege or set of privileges from a role Listing 13 Revoke a privilege or a set of privileges from a user or a role SQL connect as sysdba Connected SQL alter session set container bynd Session altered
You must have JavaScript enabled to view digital editions.