Re: Cross database update issue ... Also, for dbo-owned objects, the owner of both databases must be the ... You can execute sp_helpdb to determine the current database owners.... > User Name: Test1 Role Name=Test ... > Role Test has select permission to table t_test ... (microsoft.public.sqlserver.security)
Re: SP accessing other db ... And its dbo user was blank even db Properties shows BUILTIN\Administrator as ... Now the database name is hard-coded. ... > with System Admin permission.... >> have the same owner so that the dbo users map to the same login. ... (microsoft.public.sqlserver.security)
Re: database split before or after security? ... I created a new database in Access 2003. ... As owner, I created a new database and imported ... database, as workgroup owner and imported queries, forms and reports, ...ModifyDesign permission on no tables. ... (microsoft.public.access.security)
Re: database split before or after security? ... I created a new database in Access 2003. ... As owner, I created a new database and imported ... database, as workgroup owner and imported queries, forms and reports, ...ModifyDesign permission on no tables. ... (microsoft.public.access.security)
Re: Please help with sorting? ... I've changed the database name in the script but keep getting these errors: ... It did create fine in the master database.... if you are not the owner of this table or view. ... Make sure you have SELECT permission on that table or view. ... (microsoft.public.sqlserver.programming)
