Re: Permissions with sp

Users do not need any permissions on tables used in a stored procedure as
long as:

1) all objects are owned by the same user (SQL 2000) or have same schema
owner (SQL 2005)

2) you do not use dynamic SQL

This behavior is known as ownership chaining. See the Books Online for more
information.


--
Hope this helps.

Dan Guzman
SQL Server MVP

"Carlos Dias" <CarlosDias@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1801CAC0-5691-4146-B63C-7E2E99E87405@xxxxxxxxxxxxxxxx
Hi,

I programmed a Sp, which I gave permissions to some users to execute,
nevertheless, inside the code makes inserts and updates to tables where
they
only have select permissions. So whenever they execute them a error
message
is produced. How can i turnaround this. I want the sp to actually write in
some tables which they only have select permissions. Is there a solution.
Thanks
--
Carlos Dias


.

Relevant Pages

  • Re: Connecting to Sql Server 2005
    ... When you create the logon (or alter the login) in Enterprise Manager ... allows it the permissions it will need. ... executes the sp's I get the infamous EXECUTE permission denied on object ... I am using sql server authentication - I created a SQL server user in the ...
    (microsoft.public.dotnet.general)
  • Re: SQL CE Synching Problems
    ... Have you granted IUSER_ServerName access to your publication within SQL ... It looks like the permissions problem is getting access to the publication. ... so the issue has to be between the server tools and the publisher. ... > A request to send data to the computer running IIS has failed. ...
    (microsoft.public.sqlserver.ce)
  • Re: Sql Security ?QL
    ... Permissions on indirectly referenced objects are not checked as long as the ... Permissions to use the statementwithin the EXECUTE string are checked at ... See http://www.sommarskog.se/dynamic_sql.html for other dynamic SQL ...
    (microsoft.public.sqlserver.security)
  • Re: Logging in irrespective of database access
    ... Sysadmin role members have full permissions, ... SQL Server MVP ... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...
    (microsoft.public.sqlserver.server)
  • Re: Logging in irrespective of database access
    ... Sysadmin role members have full permissions, ... SQL Server MVP ... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...
    (microsoft.public.sqlserver.server)