Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Posts
    21

    Question Unanswered: Bypassing Ownership

    I seriously need to revoke some of the persmissions my fellow developers misuse, I want them to be able to create objects manipulate them and the data but I dont want them to create databases and dont want them to have system administrator permissions.

    when I change their login permissions all the objects they create appear with their user prefix for example programmer.Newobject, this sucks, I dont want our objects to have tons of programmer names in them making the code unreadable and unmanageable not to mention dependencies management.

    is there some simple way to bypass ownership, or make all objects appear with the dbo prefix (which is the default, so you dont need to specify it) whats the point in this ownership thing, as if I dont have enough to worry about without making life harder for myself. oh, and as I said I dont want them to use the SA login or have SA permissions.

    thanks people.

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621

    Re: Bypassing Ownership

    remove user programmer and fire:

    exec sp_addalias 'programmer','dbo'

Posting Permissions

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