Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Location
    india
    Posts
    41

    Unanswered: Any option to alter database - add space without dba previlage

    The requirement is to customize database admin activities by creating new user group. To explain in detail

    Need to create a group of user / dbauser1 which will have restriction in seeing the data but they should be able to alter database - add / remove the data file , increase or decrease the data file space when required.

    This requirement came we wanted to create a new dba group they should not be able to any user data / any table but increase / decrease / add / modify space etc.

    Is it possible if yes steps pl.

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Have you tried adding the members to the diskadmin server role?

Posting Permissions

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