Is it is possible in SQL

Asked By tusharahasan 0 points N/A Posted on - 10/09/2011

Is it possible to create user without using (create user) command?

• Status: Open
• Question Views: 1048
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS SQL Server

Best Answer by Choumen

Go To Solution

Best Answer

Best Answer

Answered By Choumen 5 points N/A #90317

Is it is possible in SQL

Hi,

I have investigated much time on Internet and I have found nothing to create user without command in SQL server. But you can create user simply by the following command in SQL server. Here are the commands.

CREATE USER user_name 

    [ { { FOR | FROM }

      {

        LOGIN login_name

        | CERTIFICATE cert_name

        | ASYMMETRIC KEY asym_key_name

      }

      | WITHOUT LOGIN

    ]

    [ WITH DEFAULT_SCHEMA = schema_name ]

Hope this will help you. If it doesn't work well please let me know. I will do more research on the Internet finding a way to solve your problem.

Thank you for your question.

About Choumen

Questions
0

Answers
4

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 10/10/2011
• Question Category: MS SQL Server

Answered By agnes Grace 0 points N/A #90318

Is it is possible in SQL

No, there is no other way to create user except "create user" command. Manay people say isql*plus can be used to create users without using "create user" command but actually isql*plus is just a GUI for sql commands so indirectly it is also using the command only.

About agnes Grace

Questions
1

Answers
46

Best Answers
9

• Vote Up 0 Vote Down

• Posted on - 10/21/2012
• Question Category: MS SQL Server