Re: How to Grant permissions to Database

From: Uri Dimant (urid_at_iscar.co.il)
Date: 08/02/05 

Date: Tue, 2 Aug 2005 10:13:11 +0300

Hi
Is the user ammember of sysadmin server role and db_owner fixed database
role

If he/she is not a member of the sysadmin fixed server role but is a member
only of the db_owner fixed database role and creates a table which belongs
to 'Tesflow' it qualified as 'Tesflow'.Table

Make sure that the user does exist in the database and given appropriate
permissions

"A.Seetharaman" <A.Seetharaman @discussions.microsoft.com> wrote in message
news:FC31B543-826B-4DED-B7F7-AE9142E74179@microsoft.com...
>I have to create new database using Stored Procedure in that I have to
>create
> a table and insert the values from another databse table . When we Create
> the
> table its shows below error
> " Server: Msg 2760, Level 16, State 1, Procedure TestProce, Line 7
> Specified owner name 'Tesflow' either does not exist or you do not have
> permission to use it."
>
>

Relevant Pages

  • how can a user who is in a role assign his role to another user?
    ... 'ABC01' is not a member of the sysadmin fixed server role or the db_owner fixed database role or the db_securityadmin fixed database role, can he assign his role to another user? ...
    (microsoft.public.sqlserver.security)
  • Re: User that can run jobs
    ... Ih the user is not a member of sysadmin server role he/she can execute jobs ...
    (microsoft.public.sqlserver.security)
  • Executing fn_trace_getinfo as non system administrator
    ... is not a member of system administrator fixed server role? ... I need to create a user with restricted privileges but still is able to get ...
    (microsoft.public.sqlserver.security)
  • Re: For Andrea...Install MSDE w/ MSDE Depl.Toolkit. cont.
    ... he's not a member of either. ... > MSDE database when it is installed locally? ... sure member of sysadmins server role.. ... Andrea Montanari ...
    (microsoft.public.sqlserver.msde)
  • RE: adding users to db fixed roles
    ... >Only members of the sysadmin fixed server role and the ... Role owners can execute sp_addrolemember ... to add a member to ... >database role can add users to any user-defined role. ...
    (microsoft.public.sqlserver.security)