I have two databases. In the first database I have a view that needs to be
able insert into a table in the second database. I want the user to only
have select permissions in the second database?s table. Because of this
restriction the view cannot insert into the table when the user inserts
into
the view. Is there some way of granting the view insert permissions to
the
table? I know this will work if the view and table are in the same
database
but I have to have them in different databases in this situation.
Re: Permissions for login? ... maintaining some level of version control for the databases.... >>data if they are the owner of the table. ...>>permissions to modify data. ... >>>able to modify data within the objects created after the object has ... (microsoft.public.sqlserver.security)
RE: missing system.mdw file ...permissions to create the file, ... >The registry key is not missing. ... Running the SCAN program from the Windows... >>| I cannot create any new databases in Access 2002 on ... (microsoft.public.access.setupconfig)
Re: one SQL DB getting info from another - user setup? ... It appears from your narrative that the Main and DB1 databases...EXEC sp_helpdb 'Main' ...SQL 2000 SP3 and is turned off by default. ... > In the permissions for Main, USER1 and USER2 are listed, but have NO ... (microsoft.public.sqlserver.security)
Re: MDB remembers old MDW ... The workgroup file is used for a session of Access - any number of databases... The mdw defines the usernames/passwords and group memberships. ...permissions are stored in the mdb file with the objects. ... (microsoft.public.access.security)
Re: Configuring SQL 2000 for use with ESRI ArcSDE ... You can assign SQL Server users to database roles using sp_addrolemember: ...Permissions are entirely application specific. ... vendor for clarification of security requirements.... I have Two databases 3 Roles ... (microsoft.public.sqlserver.server)
