what do you mean by read the stored procedure ? By default new user are
not granted anything on the database. They are mapped to the public
role (like any other user) which by default contains no permissions.
granetd the permissions to execute a stored procedure can be done using
the GRANT EXECUTE ON SomeProcedurename TO SomeUsername.
Re: public role question ... Who is the owner of the database?..."Dan Guzman" wrote: ... Windows group and thereby get sysadmin permissions.... Then I am able to create a stored procedure.... (microsoft.public.sqlserver.security)
Re: public role question ... I logged on to the database through QA as dantest. ..."Dan Guzman" wrote: ... Windows group and thereby get sysadmin permissions.... Then I am able to create a stored procedure.... (microsoft.public.sqlserver.security)
Re: Select Permission Denied On Object ... The main consideration with cross database chaining is that the security implications aren't obvious. ... On the other hand, if data are not sensitive and direct selects are no big deal, go with select permissions.... > I have a stored procedure in one database, ... (microsoft.public.sqlserver.security)
Re: Select Permission Denied On Object ... If I were to implement db chaining, what would be a good generic ... table in another database?...Permissions on indirectly referenced objects are not needed as long as the ... I have a stored procedure in one database, ... (microsoft.public.sqlserver.security)
Re: public role question ...Dan, I'm sorry but after I responded to Kalen's email I deleted the test ... Somehow the user 'dantest' was the owner of the database so I guess ... I did create a second user with only the public role for permissions and was ... Then I am able to create a stored procedure.... (microsoft.public.sqlserver.security)
