Post reply

Security ...

  • December 23, 2007 at 11:29 pm

    #121514

    Hi pals,

    I am from oracle background. I need a clarification on user creation sql server 2005. In Oracle what we normally follows is,

    Way 1

    -------

    1. We create a user(or schema what we usually call it as)

    2. Give hime permissions

    Way 2

    ------

    1.Create a user-defined Role

    2.Assign permissions to Role.

    3.Create a user

    4.Assign a role to him.

    Note : The same role can be assigned to many Users.

    But in SQL Server 2005, the user creation i feel confused.

    1.Add a Login

    2.Create a Role

    3.Create a Schema

    4.Add newly created user to Role

    What is difference between Login and Schema?

    Can anyone explain why it is so.

    Thanks & Regards.

  • December 24, 2007 at 3:49 am

    #762518

    Iam sure these link will help you 🙂

    http://www.sqlteam.com/tag/sql-server-security

    http://www.microsoft.com/sql/technologies/security/whitepapers.mspx

    http://www.microsoft.com/sql/technologies/security/default.mspx

    "More Green More Oxygen !! Plant a tree today"

  • December 24, 2007 at 5:46 am

    #762525

    the refs will clarify it in detail, but ...

    - in short a schema is nothing else than a logical rack for objects.

    All objects must be member of one and just one schema.

    - a user only is granted authority to perform stuff with objects (schema.object) , schema level, at database level or at server level, but if the users is being revoked from the db or server, all objects still remain available because of the separation of user(owner) and schema.

    Also keep in mind that one sqlserver instance hosts more than one database !

    Backup & recovery level is database (or strict database related).

    A user can have authotiry in # databases.

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • December 26, 2007 at 8:06 am

    #762677

    Thanks Friends.It helped me a lot.

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

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