Adding User to DB without Giving him the default public Role?

  • Dear All

    How to add a user login to a role in database without assigning a public role in the same database ??

    Regards

  • You cannot remove anyone from Public.  The only thing you can do is assign to denywrite and/or denyread....



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • Very true you can not avoid adding users to the public role. What I've done in the past is create a new roll ( something like AllUsers ) and grant that role the base level access that you would have given public. In fact you can generate a permissions script and do a bit of find and replace to make it easy. Then you give public nothing. Once public has nothing there should be no concerns if a user has public access.

    Chuck

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply