When the new user has been created in Oracle database, the new user cannot do anything with the database. The database admin has to grant privilege to that user. First privilege is
SQL> grant connect to Tommy;
Grant succeed.
The privilege allow the user Tommy to be able to connect to the database. In order for user Tommy to use the resource, granting resource must be follow:
SQL> grant resource to TOMMY;
Grant succeeded.
Now, the user Tommy can use resource like table space. There are other options in privilege to be granted. From my practice, after I create the new user, I also grant EXP_FULL_DATABASE to the user.
SQL> grant EXP_FULL_DATABASE to TOMMY;
This option allows the user to create and drop tables and other objects.
No comments:
Post a Comment