Grant these two default roles in addition to their corresponding default privileges to each one of the users that you created. Log into the database where you need to grant privileges to users. Signing in to SQLPlus as system/manager and other administrative user.I created a few new users in Oracle. However, when running sqlplus, all of them have to properly accredited the table names in query. In the event you really poke around with Oracle you ll realize that the sys account is blocked from a variety of tasks therefore we must create some users.
http://programmingunit.com/2013/09/14/create-new-user-oracle-sql-plus/
No comments:
Post a Comment