Results 1 to 2 of 2

Thread: help me please

  1. #1
    Join Date
    Jan 2004
    Posts
    37

    Unanswered: help me please

    if initially a Quota of 20MB for tablespace DATA01 was assigned . You want to prevent user from creating any new objects in this tablespace, but still allow him access to the objects that currently exist. What should you do?

  2. #2
    Join Date
    Feb 2004
    Posts
    45

    Re: help me please

    You should change the password to the userid and dont tell the current user what it is, then you should create another id for the user and assign select rights to the original scema elements.
    HTH
    Cliff
    Originally posted by chiranjib_s
    if initially a Quota of 20MB for tablespace DATA01 was assigned . You want to prevent user from creating any new objects in this tablespace, but still allow him access to the objects that currently exist. What should you do?
    It was working just 5 minutes ago - I promise !

Posting Permissions

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