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