Results 1 to 5 of 5

Thread: Roles creation issue in oracle database

  1. #1
    Join Date
    Nov 2009
    Posts
    39

    Roles creation issue in oracle database

    I am new to database , I am having a small assignment in my course .The assignment is like that..Assume you are the DBA of a large international banking concern (sites in three countries). You have just taken over the position and found that there is currently no roles used in the database. What roles do you need to create? Consider job function, location, and any other criteria you can identify.
    They are asking the role alone not the code in oracle , so please help me to solve the Roles creation issue in oracle database.

  2. #2
    Join Date
    Oct 2005
    Posts
    2,394

    Roles description in oracle

    The role is a powerful and secure feature of oracle database.It is a group of privileges that can be granted to one or more than one users and role obviously.

    If you are working in an organization as a DBA and you are responsible to create and manage the database user. In a particular organization, there are so many employees are working on different posts and their needs of data usage are also different.It is not so easy to write the grant statement for every user according to their accessibility. As a DBA you need to categorize the user in different sections or departments and after that you can create and use the role and easily grant the permission to every users of database.

  3. #3
    Join Date
    May 2008
    Posts
    2,393

    Roles creation in oracle database

    Creating Role in database:
    If you are not working as a DBA,then you need to have the privileges to create the role .

    The syntax for creating role:

    Code:
    CREATE ROLE_NAME 
    [ NOT IDENTIFIED |
    IDENTIFIED {BY password | USING [schema.] package | EXTERNALLY | GLOBALLY } ;
    ROLE_NAME - identifies the name of the Role.

    NOT IDENTIFIED means the role is enabled and no need for password to enable it.

    IDENTIFIED means the role creator(user) must be authorized by particular method before enabling the role and the respective options are given like by PASSWORD, EXTERNALLY and GLOBALLY.

  4. #4
    Join Date
    Feb 2008
    Posts
    1,856

    Granting privileges to Roles in oracle database

    After the creation,you need to grant some privileges to the role.Suppose, I have different posts in organization like manager and executive. I will create a role named " MANAGER_ROLE".
    Now, its time to assign some privileges to that created role. I want to grant only SELECT, INSERT AND UPDATE PRIVILEGE to the manager of every managers.That would be as follows :

    Code:
    CREATE ROLE MANAGER_ROLE
    IDENTIFIED BY MAN123;
    Granting the privilege to the role:

    Code:
    GRANT SELECT,INSERT,UPDATE ON <Object_name> TO MANAGER_ROLE;

  5. #5
    Join Date
    Jan 2008
    Posts
    1,521

    Assigning Roles to users in oracle database

    Now, you can easily grant the created role to one or more users of the database.The syntax would be as follows:

    Code:
    GRANT name_of_role TO name_of_user;
    The implementation of the role would be as follows for SCOTT user:

    Code:
    GRANT MANAGER_ROLE to scott;

Similar Threads

  1. sql server new database creation error. .
    By Rizwan_Akhter in forum Windows Software
    Replies: 1
    Last Post: 17-10-2011, 11:41 AM
  2. Creation of tablespace in oracle database
    By Garlands in forum Software Development
    Replies: 3
    Last Post: 05-02-2010, 09:58 PM
  3. Users,Roles and privileges in Oracle
    By Garlands in forum Software Development
    Replies: 4
    Last Post: 29-01-2010, 01:56 PM
  4. Creation of a database in OOo
    By Theodore in forum Software Development
    Replies: 3
    Last Post: 18-03-2009, 06:31 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •