none
how to give owner permission for database table for SQL Developer Edition

    Question

  • HI,
     I hope this is a right place to ask, if not, please point me the right place.
    I like to give owner permission for my database table. How can i do that for my database table?

    Please help me.

    Thanks.
    Monday, September 29, 2008 3:15 AM

Answers

  •  

    And if you are not comfortable with sql

    you can do this using GUI

    go to management studio and

     

    DATABASE >> SECURITY >> RIGHT CLICK PROPERTIES ON USER "cute_Developer\kyaw "

    >> SECURATBLES >>CLICK ADD >> SEELCT SPECIFIC OBJECT >> CLICK OBJECT TYPES >>

    SELECT TABLES >>CLICK BROWSE >>

    SELECT TABLE ON WHICH YOU WANT TO GRANT PERMISSION >>

    CHECK ON GRANT BOX IN FRONT OF "TAKE OWNERSHIP"

    Tuesday, September 30, 2008 11:00 AM
    Moderator
  •  

    you entered the cute_Developer/kyaw manualy or you browsed it?

    If Login with same name don't exists then can't create the user.

    Hang on I'll get the detail documents on login and users for you.

     

    See this

    Wednesday, October 08, 2008 3:17 AM
    Moderator
  •  

    It means you already have the login with that name.

    Don't confuse Login with Usres.

    While creating the user at single database you just need to browse the Login name from GUI.

     

    I try to simplify for you.

    Steps to be involved

     

    1. Create Login. At main secuity tab in management studio.  As error is saying in your case you already created that one.

    2. Go to the specific database and security create new user, enter username and browse the same Login name from the window.

    3. Assign the Take owenrship rights to the user.

    Wednesday, October 08, 2008 7:04 PM
    Moderator

All replies

  •  

    you can try this

    Code Snippet

     

    GRANT TAKE OWNERSHIP ON [dbo].[tablename] TO [username]

    GO

     

     

    Monday, September 29, 2008 6:29 AM
    Moderator
  • I followed ur way..like below

    GRANT TAKE OWNERSHIP BalloonShop Category TO cute_Developer\kyaw
    GO

    I got error...

    Msg 102, Level 15, State 1, Line 1
    Incorrect syntax near 'TAKE'.

    pls help
    Monday, September 29, 2008 7:41 PM
  • try this way... you missed the ON keyword

     

    Code Snippet

    GRANT TAKE OWNERSHIP ON [BalloonShop Category] TO [cute_Developer\kyaw]

    GO

     

     

     

    Tuesday, September 30, 2008 2:40 AM
    Moderator
  • error again. i copied and pasted the code and error is below.

    Msg 15151, Level 16, State 1, Line 1
    Cannot find the object 'BalloonShop Category', because it does not exist or you do not have permission.

    Tuesday, September 30, 2008 10:47 AM
  • as error message suggesting

    1. BalloonShop Category table exists? spelling is correct?

    2. By which login you executing the script does that user have the GRANT OWNERSHIP rights on same table?

     

    Tuesday, September 30, 2008 10:51 AM
    Moderator
  •  

    And if you are not comfortable with sql

    you can do this using GUI

    go to management studio and

     

    DATABASE >> SECURITY >> RIGHT CLICK PROPERTIES ON USER "cute_Developer\kyaw "

    >> SECURATBLES >>CLICK ADD >> SEELCT SPECIFIC OBJECT >> CLICK OBJECT TYPES >>

    SELECT TABLES >>CLICK BROWSE >>

    SELECT TABLE ON WHICH YOU WANT TO GRANT PERMISSION >>

    CHECK ON GRANT BOX IN FRONT OF "TAKE OWNERSHIP"

    Tuesday, September 30, 2008 11:00 AM
    Moderator
  • I followed

    DATABASE>>SECURITY>>..
    but i cant see USER folder... i got
    Login
    Server Roles
    Credentials

    these above three under SECURITY folder..... i am using SQL Developer Edition 2005.

    pls advice me more.
    Tuesday, September 30, 2008 10:50 PM
  • Hi,

    Don't go at the main security folder.

    Here database means name of the database in which table exists.

    For example your table is in XYZ database.

    XYX >> Security >> USERS >> In users right click on user to whom you want to grant permission.

    then follow the steps.

     

    Wednesday, October 01, 2008 2:49 AM
    Moderator
  • hi,

    in Security>> USERS>> i got 4 users there
    1.dbo
    2.guest
    3.INFORMATION_SCHEMA
    4.sys

    only exit.
    do i need to create new user name??

    please see my database in below link

    http://thargyi.net/DataBasePhoto.aspx

    I just copy my database and put on my page. please advice me. i not good in sql.

    thanks
    Wednesday, October 01, 2008 9:59 PM
  •  

    Sorry forlate reply

    yes, I guess you havn't added the user cute_Developer\kyaw to the database (until and unless same user is DBO)

    You first need to add the user to the Database

    By right click on USERS you can add new user.
    Monday, October 06, 2008 7:20 AM
    Moderator
  • HI,
    I tried to create new user, but i got error
    create failed to USER'cute_developer' (microsoft.sqlserver.smo)

    pls show me step by step or any link .
    thanks
    Monday, October 06, 2008 11:05 AM
  •  

    Can tell me the steps you are following?

    Does Login name for the same user exists in Sql server?

    Monday, October 06, 2008 11:18 AM
    Moderator
  • HI ,
    I followed you steps which you have provided above.

    Databases>>Thargyi(mydatabase)>>Security>> Users...

    <!-- under Users Folder.. 4 differrent types users exited.
    1.dbo
    2.guest
    3.INFORMATION_SCHEMA
    4.sys
    --!>

    i did right click on Users>>and click New User...

    entered in User Name Text box :  kyaw
    and in Login name Text box : cute_Developer/kyaw

    and clicked check box in db_owner from Schemas owned by this user and Database roel membership.


    My database is using window authentication..not sql

    CUTE_DEVELOPER\SQLEXPRESS(SQL Server9.0.3068 - cute_Developer\kyaw ..

    I using sql 2005 express edition now....

    Please help me out.. i am really tired now..
    Thanks for your help
    Tuesday, October 07, 2008 10:44 PM
  •  

    you entered the cute_Developer/kyaw manualy or you browsed it?

    If Login with same name don't exists then can't create the user.

    Hang on I'll get the detail documents on login and users for you.

     

    See this

    Wednesday, October 08, 2008 3:17 AM
    Moderator
  • Hi,
    I followed the steps which the link has provided.

    Databases>>Security>>Login>>New User..

    Filled up all requirements in Text Boxes and check Boxes.

    i got errror

    it said

    The login already has an account under a different name(Microsoft SQL Server, Error:15063)..

    Please any idea for that. I really needed to be sorted it out.

    Thanks,
    Wednesday, October 08, 2008 4:21 PM
  •  

    It means you already have the login with that name.

    Don't confuse Login with Usres.

    While creating the user at single database you just need to browse the Login name from GUI.

     

    I try to simplify for you.

    Steps to be involved

     

    1. Create Login. At main secuity tab in management studio.  As error is saying in your case you already created that one.

    2. Go to the specific database and security create new user, enter username and browse the same Login name from the window.

    3. Assign the Take owenrship rights to the user.

    Wednesday, October 08, 2008 7:04 PM
    Moderator
  • Hi Mangal,

    Thanks for your help.. I sorted it out. Thanks for being patient and helped me out.


    Wednesday, October 08, 2008 9:11 PM