Is it is possible in SQL

Asked By 0 points N/A Posted on -
qa-featured

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

SHARE
Best Answer by Choumen
Best Answer
Best Answer
Answered By 5 points N/A #90317

Is it is possible in SQL

qa-featured

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.

Answered By 0 points N/A #90318

Is it is possible in SQL

qa-featured

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.

Related Questions