PHISSUG

Home of Filipino Sql Server Enthusiasts
Welcome to PHISSUG Sign in | Join | Help
in Search

Assigning User Roles on MSSQL 2005 Express Edition

Last post 09-11-2007, 12:23 AM by ggsubscribe. 7 replies.
Sort Posts: Previous Next
  •  09-09-2007, 7:59 PM 2002

    Assigning User Roles on MSSQL 2005 Express Edition

    I am a new user of SQL especially SQL 2005 Express Edition. Is this possible?
  •  09-09-2007, 9:36 PM 2003 in reply to 2002

    Re: Assigning User Roles on MSSQL 2005 Express Edition

    mpMS:
    I am a new user of SQL especially SQL 2005 Express Edition. Is this possible?

    Did you just create a new login in Windows? If that so and you're in the Administrators group, you are mapped in the Builtin\Administrators group of the SQL Server. You may log in and create your first database.

    Regardless of your group, you can always log in using Integrated Security unless you are explicitly denied in the SQL Server. Just try logging in for now.

  •  09-09-2007, 9:55 PM 2004 in reply to 2003

    Re: Assigning User Roles on MSSQL 2005 Express Edition

    thanks for the immediate response. I would like to rephrase my question. I wanted to create an account that will be db_owner of specific database
  •  09-09-2007, 10:30 PM 2005 in reply to 2004

    Re: Assigning User Roles on MSSQL 2005 Express Edition

    mpMS:
    thanks for the immediate response. I would like to rephrase my question. I wanted to create an account that will be db_owner of specific database

    After creating your login, do the following

    1) Ensure that the login is a user of the database. Go to the User folder of your database and add the user. You can find the User folder in the Security folder of your database.

    2) There, you should specify the newly created login. You can browse for it if you want. Then check the role in the lowermost checkbox to which this login should be a member of. You can see the role "dbo_owner" there.

    Be aware that in order to do this, you must have high privileges in the database. If you are a local administrator of the database, there's no problem because accounts in the Administrators group is mapped to the dbo schema and that means you also own the database. The safe practice is to create a database using local administror account.

  •  09-10-2007, 2:52 AM 2017 in reply to 2005

    Re: Assigning User Roles on MSSQL 2005 Express Edition

    how can I see the roles if I dont have management console for sql 2005 express edition?
  •  09-10-2007, 3:03 AM 2019 in reply to 2017

    Re: Assigning User Roles on MSSQL 2005 Express Edition

    mpMS:
    how can I see the roles if I dont have management console for sql 2005 express edition?

    Oops, you didnt say you don't have one. Well, there's definitely script equivalent for all the task you do with clicks but I rather suggest you download this This will save you a lot of miseries in the future. Life should be easy as much as possible. ;)

  •  09-10-2007, 11:16 PM 2027 in reply to 2002

    Re: Assigning User Roles on MSSQL 2005 Express Edition

    mpMS:
    I am a new user of SQL especially SQL 2005 Express Edition. Is this possible?
    Great, your post reminded me of something and made me write a blog about it. Read here.
  •  09-11-2007, 12:23 AM 2029 in reply to 2027

    Re: Assigning User Roles on MSSQL 2005 Express Edition

    dreamlordzwolf:
    mpMS:
    I am a new user of SQL especially SQL 2005 Express Edition. Is this possible?
    Great, your post reminded me of something and made me write a blog about it. Read here.

    heheheh. now PHISSUG just experienced a 100% increase in blogger count. Very nice stat! Stick out tongue [:P]

View as RSS news feed in XML
Powered by Community Server (Personal Edition), by Telligent Systems