|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
permissions to delete MSysObjectshow can I have a permission to delete a MSysObject? I tried changing
permissions of users, owners and groups, but nothing helped. I simply want to delete a few tables. I have this problem on a MS Access Database Windows 2000 Version, and I have the 2007 Beta version of the application itself Ben Freyer wrote:
> how can I have a permission to delete a MSysObject? I tried changing You cannot. Why do you think you need to? You should turn off the option to > permissions of users, owners and groups, but nothing helped. I > simply want to delete a few tables. I have this problem on a MS > Access Database Windows 2000 Version, and I have the 2007 Beta > version of the application itself see system tables and just forget that they are even there. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com Rick,
The question was probably not right. I do not want to delete a MSysObject. That was actually the message which popped-up when i wanted to delete a normal (I repeat, a normally created table) not a systems' table. However, I found the solution. I changed the permissions under the administrator and it worked. Case closed. For all others thanks; and Rick never intent to be a tutor; your sarcastic reverse question "Why do you think you need to" is not welcome. Cheers, Show quoteHide quote "Rick Brandt" wrote: > Ben Freyer wrote: > > how can I have a permission to delete a MSysObject? I tried changing > > permissions of users, owners and groups, but nothing helped. I > > simply want to delete a few tables. I have this problem on a MS > > Access Database Windows 2000 Version, and I have the 2007 Beta > > version of the application itself > > You cannot. Why do you think you need to? You should turn off the option to > see system tables and just forget that they are even there. > > -- > Rick Brandt, Microsoft Access MVP > Email (as appropriate) to... > RBrandt at Hunter dot com > > > Ben,
I don't detect any "sarcastic" tone in Rick's question. He was simply trying to ascertain why you thought deleting a system table might be necessary. Show quoteHide quote "Ben Freyer" <BenFre***@discussions.microsoft.com> wrote in message news:1152A756-1B00-4CDC-BE0D-0CE622808D9F@microsoft.com... > Rick, > > The question was probably not right. I do not want to delete a > MSysObject. > That was actually the message which popped-up when i wanted to delete a > normal (I repeat, a normally created table) not a systems' table. > However, > I found the solution. I changed the permissions under the administrator > and > it worked. Case closed. For all others thanks; and Rick never intent to > be > a tutor; your sarcastic reverse question "Why do you think you need to" is > not welcome. > > Cheers, > > "Rick Brandt" wrote: > >> Ben Freyer wrote: >> > how can I have a permission to delete a MSysObject? I tried changing >> > permissions of users, owners and groups, but nothing helped. I >> > simply want to delete a few tables. I have this problem on a MS >> > Access Database Windows 2000 Version, and I have the 2007 Beta >> > version of the application itself >> >> You cannot. Why do you think you need to? You should turn off the >> option to >> see system tables and just forget that they are even there. >> >> -- >> Rick Brandt, Microsoft Access MVP >> Email (as appropriate) to... >> RBrandt at Hunter dot com >> >> >> Ben Freyer wrote:
> Rick, I fail to see anything the slightest bit sarcastic about that question. When > > The question was probably not right. I do not want to delete a > MSysObject. That was actually the message which popped-up when i > wanted to delete a normal (I repeat, a normally created table) not a > systems' table. However, I found the solution. I changed the > permissions under the administrator and it worked. Case closed. For > all others thanks; and Rick never intent to be a tutor; your > sarcastic reverse question "Why do you think you need to" is not > welcome. someone indicates they are having trouble accomplishing something that should not be accomplished it is perfectly reasonable to ask for their reasoning behind the attempt. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com Hi, Ben.
> and Rick never intent to be As a full-fledged member of the Sarcasm Brigade, I can say it would not be wise > a tutor; your sarcastic reverse question "Why do you think you need to" is > not welcome. for Rick to quit his day job, as he wouldn't win us any points for our team. As for you, Ben, would you care for some cheese . . . ? Gunny Show quoteHide quote "Ben Freyer" <BenFre***@discussions.microsoft.com> wrote in message news:1152A756-1B00-4CDC-BE0D-0CE622808D9F@microsoft.com... > Rick, > > The question was probably not right. I do not want to delete a MSysObject. > That was actually the message which popped-up when i wanted to delete a > normal (I repeat, a normally created table) not a systems' table. However, > I found the solution. I changed the permissions under the administrator and > it worked. Case closed. For all others thanks; and Rick never intent to be > a tutor; your sarcastic reverse question "Why do you think you need to" is > not welcome. > > Cheers, > > "Rick Brandt" wrote: > >> Ben Freyer wrote: >> > how can I have a permission to delete a MSysObject? I tried changing >> > permissions of users, owners and groups, but nothing helped. I >> > simply want to delete a few tables. I have this problem on a MS >> > Access Database Windows 2000 Version, and I have the 2007 Beta >> > version of the application itself >> >> You cannot. Why do you think you need to? You should turn off the option to >> see system tables and just forget that they are even there. >> >> -- >> Rick Brandt, Microsoft Access MVP >> Email (as appropriate) to... >> RBrandt at Hunter dot com >> >> >> > As a full-fledged member of the Sarcasm Brigade, I can say it would not be <grin> <snicker> <snort>> wise for Rick to quit his day job, as he wouldn't win us any points for > our team. As for you, Ben, would you care for some cheese . . . ? .. . . to go with that whine? :-)
Gunny Show quoteHide quote "'69 Camaro" <ForwardZERO_SPAM.To.69Camaro@Spameater.orgZERO_SPAM> wrote in message news:OHJSPefKHHA.2456@TK2MSFTNGP06.phx.gbl... > Hi, Ben. > >> and Rick never intent to be >> a tutor; your sarcastic reverse question "Why do you think you need to" is >> not welcome. > > As a full-fledged member of the Sarcasm Brigade, I can say it would not be > wise for Rick to quit his day job, as he wouldn't win us any points for our > team. As for you, Ben, would you care for some cheese . . . ? > > Gunny > > > "Ben Freyer" <BenFre***@discussions.microsoft.com> wrote in message > news:1152A756-1B00-4CDC-BE0D-0CE622808D9F@microsoft.com... >> Rick, >> >> The question was probably not right. I do not want to delete a MSysObject. >> That was actually the message which popped-up when i wanted to delete a >> normal (I repeat, a normally created table) not a systems' table. However, >> I found the solution. I changed the permissions under the administrator and >> it worked. Case closed. For all others thanks; and Rick never intent to be >> a tutor; your sarcastic reverse question "Why do you think you need to" is >> not welcome. >> >> Cheers, >> >> "Rick Brandt" wrote: >> >>> Ben Freyer wrote: >>> > how can I have a permission to delete a MSysObject? I tried changing >>> > permissions of users, owners and groups, but nothing helped. I >>> > simply want to delete a few tables. I have this problem on a MS >>> > Access Database Windows 2000 Version, and I have the 2007 Beta >>> > version of the application itself >>> >>> You cannot. Why do you think you need to? You should turn off the option >>> to >>> see system tables and just forget that they are even there. >>> >>> -- >>> Rick Brandt, Microsoft Access MVP >>> Email (as appropriate) to... >>> RBrandt at Hunter dot com >>> >>> >>> > > '69 Camaro wrote:
> As a full-fledged member of the Sarcasm Brigade, I can say it would Hey! I resent that remark. I can be just as sarcastic as the next guy ;-)> not be wise for Rick to quit his day job, as he wouldn't win us any > points for our team. [snip] ahem... Ben, I apologize. It was wrong of me to assume that you wanted to delete the MSysObjects table just because you posted with a subject of "permissions to delete MSysObjects". In the future I will endeavor to probe the true meaning of posted questions without relying solely on their textual content. (how was that?) -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com > (how was that?) Point.Gunny Show quoteHide quote "Rick Brandt" <rickbran***@hotmail.com> wrote in message news:KeBkh.7613$yC5.3742@newssvr27.news.prodigy.net... > '69 Camaro wrote: >> As a full-fledged member of the Sarcasm Brigade, I can say it would >> not be wise for Rick to quit his day job, as he wouldn't win us any >> points for our team. [snip] > > Hey! I resent that remark. I can be just as sarcastic as the next guy ;-) > > ahem... > > Ben, I apologize. It was wrong of me to assume that you wanted to delete the > MSysObjects table just because you posted with a subject of "permissions to > delete MSysObjects". In the future I will endeavor to probe the true meaning > of posted questions without relying solely on their textual content. > > (how was that?) > > > -- > Rick Brandt, Microsoft Access MVP > Email (as appropriate) to... > RBrandt at Hunter dot com > > > '69 Camaro wrote:
> > (how was that?) Excellent!> > Point. (another point?) -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com >> > (how was that?) Pretty good . . . for the first day on the job. I suppose you want to talk >> >> Point. > > Excellent! > > (another point?) salary? ;-) Gunny '69 Camaro wrote:
> > > > (how was that?) I have no desire for monetary compensation.> > > > > > Point. > > > > Excellent! > > > > (another point?) > > Pretty good . . . for the first day on the job. I suppose you want > to talk salary? ;-) > > Gunny (that one has to be worth two points) -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com > I have no desire for monetary compensation. You'll have to take that up with the Complaint Department. I just work here.> > (that one has to be worth two points) Gunny Show quoteHide quote "Rick Brandt" <rickbran***@hotmail.com> wrote in message news:0TBkh.7624$yC5.3076@newssvr27.news.prodigy.net... > '69 Camaro wrote: >> > > > (how was that?) >> > > >> > > Point. >> > >> > Excellent! >> > >> > (another point?) >> >> Pretty good . . . for the first day on the job. I suppose you want >> to talk salary? ;-) >> >> Gunny > > I have no desire for monetary compensation. > > > (that one has to be worth two points) > > -- > Rick Brandt, Microsoft Access MVP > Email (as appropriate) to... > RBrandt at Hunter dot com > > You'll have to take that up with the Complaint Department. I just work All complaints will be, from now on, handled by the Department of Silly > here. > Arguments. > All complaints will be, from now on, handled by the Department of Silly <SNORK!>> Arguments. Gunny Show quoteHide quote "Lynn Trapp" <ltrappNoSpam@ltcomputerdesigns.com> wrote in message news:e1e2eopKHHA.4460@TK2MSFTNGP03.phx.gbl... >> You'll have to take that up with the Complaint Department. I just work here. >> > > All complaints will be, from now on, handled by the Department of Silly > Arguments. > > -- > > Lynn Trapp > Microsoft MVP (Access) > www.ltcomputerdesigns.com > 
Other interesting topics
How secure is Access 2007
Access 2007 Security Shared mdw user level security Disable Shift Key in Access 2007? no permissions for any users user and group permissions on basis of data Copy Forms and Tables from Secure DB to other Secure DB EuroPKI07 Call for Papers How to hide Database Window for users |
|||||||||||||||||||||||
