Post reply

create user from | for login - any difference?

  • September 6, 2016 at 8:36 am

    #312853

    Hi,

    the syntax for creating an user in T-SQl allows both

    create user a from login a

    -- as well as

    create user a for login a

    I wonder if there is any difference and what ANSI SQL standard is?

    Any ideas?

    Thanks,

    Sue

    Susanne

  • September 6, 2016 at 8:42 am

    #1899353

    No difference whatsoever.

    DCL (users, permissions and the like) are highly dependant on the vedor dialect and the implementation. As far as I know, there is no standard for this.

    Oracle, for instance, does not have the notion of server principals and database principals, as the server IS the database, so creating a user for a login is something you cannot do.

    -- Gianluca Sartori

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

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