|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Change Ownership of Database Object (?)When working with User Level Security, is it normal for the
owner of a database to *not* be able to change the ownership of the database object? -- Thanks, croy Yes (assuming you mean via the security dialogs). You normally change
the owner of the database object, by creating a new mdb while logged in as the user you want to own the database. If you need to change the owner, you'd create the new database, and then import all the objects from your old database. The permissions won't travel with the import, so you'd use a utility such as Jeff Conrad's to transfer the permissions... http://www.accessmvp.com/SDaigle/index.htm Joan Wild MS Access MVP croy wrote: Show quoteHide quote > When working with User Level Security, is it normal for the > owner of a database to *not* be able to change the ownership > of the database object? > On Mon, 05 Jan 2009 19:31:13 -0500, Joan Wild
<jwild@nospamtyenet.com> wrote: >Yes (assuming you mean via the security dialogs). You normally change By "you'd", you mean the prospective new owner, right?>the owner of the database object, by creating a new mdb while logged in >as the user you want to own the database. > >If you need to change the owner, you'd create the new database, and then >import all the objects from your old database. > The permissions won't Thanks Joan. Another keeper!>travel with the import, so you'd use a utility such as Jeff Conrad's to >transfer the permissions... > http://www.accessmvp.com/SDaigle/index.htm croy wrote:
> On Mon, 05 Jan 2009 19:31:13 -0500, Joan Wild Yes> <jwild@nospamtyenet.com> wrote: > >> Yes (assuming you mean via the security dialogs). You normally change >> the owner of the database object, by creating a new mdb while logged in >> as the user you want to own the database. >> >> If you need to change the owner, you'd create the new database, and then >> import all the objects from your old database. > > By "you'd", you mean the prospective new owner, right? Joan Wild MS Access MVP  
Other interesting topics
CreateWorkspace does not work for me
Capture NT username can't disable shift key with faq_DisableShiftKeyBypass function ACCDE I'm drawing a blank... Help with Splitting and Security Issues RWOP and passing variables to a function Forgotten password and reloading Access fastest way of distributing a split and secured database Using logon name and password within a form |
|||||||||||||||||||||||
