Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002
    Posts
    47

    Unanswered: need to be local admin? dumb question

    Dumb question:
    Do I need to be a local admin on my PC to create a database?


  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1

    Re: need to be local admin? dumb question

    Originally posted by ksexton
    Dumb question:
    Do I need to be a local admin on my PC to create a database?

    Not exactly. But you need SYSADM or SYSCTRL authority, which I think is given to the local Administrators group on Windows by default. If you create another group and assign it, say, SYSCTRL authority (UPDATE DBM CFG USING SYSCTRL_GROUP <group name>) then the members of that group will be able to create databases.

Posting Permissions

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