Re: Is there cascading permission?
Yes, it is.
"michael" <howlinghound@xxxxxxxxxxxxx> wrote in message
news:CAB858A0-22F5-410C-842E-A0FE19C84343@xxxxxxxxxxxxxxxx
Let's say that I have a view that has no explicit permissions defined for
users. Let's also say that I write a stored procedure which uses this
view.
Now, if I give explicit permissions to a user to EXEC the stored
procedure,
will the procedure execute correctly even if I don't explicitily give
permissions (such as SELECT) for the user to the view?
--
Michael Hockstein
.
Relevant Pages
- Re: Is there cascading permission?
... explicit permissions defined for the objects consumed within the stored ... yes, it will, unless you have dynamic sql within a stored procedure, then ... Michael Hockstein ...
(microsoft.public.sqlserver.security) - Re: noise words, @@ERROR, and stop and resume indexing
... EXEC sp_fulltext_catalog 'adsfull', 'stop' ... > 1) check noise words inside stored procedure ... > can be solved by changing the language specific file with noise words ... ...
(microsoft.public.sqlserver.fulltext) - source text file as input parameter from a stored procedure
... I am using an active X script in combination with a global ... transform task that loads data from a .txt file to a table. ... I can also tell that the stored procedure is correctly passing in the ... EXEC sp_OAGeterrorinfo @object, @hr ...
(microsoft.public.sqlserver.dts) - Re: Repeating 3 Datapump actions between the same datasource/destinati
... How to loop through a global variable Rowset ... > exec p_PullDataForDates1 20050101,20050131 ... > task that configure the SourceSQLStatement for the 2 pumps (to fill in the ... > blanks for the stored procedure parameter). ...
(microsoft.public.sqlserver.dts) - Re: Stored Procedure Fails Only When Called By Agent
... Stored Procedure 1: ... EXEC sp_addlinkedserver '10.1.2.10', 'SQL Server' ... LOCALMACHINE\myaccount/pass3, the same account that owns the job. ...
(microsoft.public.sqlserver.replication) |
|
