1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

administration

Discussion in 'Server Administration and Options' started by tatou, Jun 2, 2014.

  1. tatou

    tatou Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Hello Oracle pro,

    I want manage users in oracle 11g
    so I have a adminstrator user for users controler,
    then another an owner user who have the objects : tables , packages, indexes
    and I should add two others users user1 & user2 that i will connect to data base by 2 applications that insert, delete, update and execute function
    so my question i should add quota for tablespace for owner or for the user1 and user2

    thanx for your appreciated help
     
  2. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    626
    Likes Received:
    129
    Trophy Points:
    810
    Location:
    Russian Federation
    Hi.

    You proceeding from the tasks shall define: whether to limit on space the user or not.
    I.e. proceeding from the business functions executed by users.
     
  3. ocprep

    ocprep Forum Advisor

    Messages:
    277
    Likes Received:
    76
    Trophy Points:
    410
    Location:
    Orlando, Florida
    The user that owns the tables must have QUOTA assigned that is sufficient for the space that will be taken up by them.

    Users that simply INSERT data into those tables do not need to be granted any QUOTA.
     
  4. tatou

    tatou Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    ok it's clear thnx
     
  5. anil prajapati

    anil prajapati Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    thane
    Hi,

    thks for it...