DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: this is strange.

  1. 03-27-2001, 07:24 PM #1
    looser
    looser is offline Junior Member
    Join Date
    Feb 2001
    Posts
    51
    When I created a user, I had assigned them with
    quota 100m on users

    when I check in DBA Studio, it shows that all my users have unlimited_tablespace.


    am I looking at the wrong thing here?

    please advise.

    thanks.
    Reply With Quote Reply With Quote
  2. 03-27-2001, 07:45 PM #2
    jmodic
    jmodic is offline Super Moderator
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    You must also have granted him CONNECT and/or RESOURCE role, which inheritably grants UNLIMITED QUOTA to that user.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?
    Reply With Quote Reply With Quote
  3. 03-28-2001, 10:54 AM #3
    looser
    looser is offline Junior Member
    Join Date
    Feb 2001
    Posts
    51

    Unhappy ummm

    so does this mean, that the quota I have set when create the user is not valid?

    and if I remove unlimited_tablespace from these users, then at that point, the quota will be apply correct?


    thanks in advance
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width