Oracle Magazine, Nov/Dec 2017
Database Application Developer and DBA BEYOND SQL 101 granted to the BEYOND_ 101 user via the GRANT privilege TO username syntax Additionally the CREATE TABLE system privilege is granted to the BEYOND_ 101 user demonstrating that multiple system privileges can be conferred in a single grant statement Listing 7 also demonstrates how the BEYOND_ 101 user is now able to successfully log in to the database and create and populate a table stored in the USERS tablespace Listing 6 User must be granted a system privilege to log in to the database SQL connect beyond_ 101@ bynd Enter password ERROR ORA 01045 user BEYOND_ 101 lacks CREATE SESSION privilege logon denied Listing 7 User can now log in to the database and create a table in its schema SQL connect as sysdba Connected SQL alter session set container bynd ORACLE MAGAZINE NOVEMBER DECEMBER 2017 96 Session altered SQL GRANT CREATE SESSION create table TO beyond_ 101 Grant succeeded SQL connect beyond_ 101@ bynd
You must have JavaScript enabled to view digital editions.