Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
Solved
when is an owner not an owner
Posted on 2002-04-10
I've set up my 'non-sa' account as owner of a particular db (sql2k sp2). I was probably logged in as sa when I created the db using DTS from an existing db.
When I connect from my workstation using MSAccess2k via an odbc connection using the non-sa account i find that I don't have ability to create new records. If I connect as sa i can.
looking at EM's Users for that db my non-sa login has checks for 'public' and 'db_owner'. I didn't (don't) think any of the other roles are anything more than subsets of db_owner, yes? So why isn't being owner good enough for Access.
My primary concern here isn't so much connecting via Acess...the db exists only to give stuff to IIS/web pages. I'm wondering if this indicates other things that may bite my butt going forward.
thankx
--steve...
When I connect from my workstation using MSAccess2k via an odbc connection using the non-sa account i find that I don't have ability to create new records. If I connect as sa i can.
looking at EM's Users for that db my non-sa login has checks for 'public' and 'db_owner'. I didn't (don't) think any of the other roles are anything more than subsets of db_owner, yes? So why isn't being owner good enough for Access.
My primary concern here isn't so much connecting via Acess...the db exists only to give stuff to IIS/web pages. I'm wondering if this indicates other things that may bite my butt going forward.
thankx
--steve...
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
4
-
3
7 Comments
Yep...it's just linked tables through Access via the non-sa account that's having a problem. SA/Access works.
I have web pages using the same non-sa, DSN-based connection able to insert and update.
thankx
--steve...
I have web pages using the same non-sa, DSN-based connection able to insert and update.
thankx
--steve...
But it works in query analyser? Hmmm.
It sounds like your connection to the ODBC's. The web stuff that works, is it asp? Are you getting any error messages in Access? If so, where, when and what?
It sounds like your connection to the ODBC's. The web stuff that works, is it asp? Are you getting any error messages in Access? If so, where, when and what?
No error messages...just a beep if trying to edit a cell and the 'insert record' button at the bottom of the frame is grayed out
[...pause...]
jeeze...i've just gone over there to reproduce whatever dialog box response i'd gotten when typing in the bottem row...and _now I can't reproduce any of the behaviors. [sigh] later today I'll take smoe time to create a new db from scratch (client-side) and see if the read-only issue reoccurs.
The web stuff is asp...uses a connection string like:
dsn=myDb;uid=not_sa;pwd=th
When linking the table from MSAccess I point to the same DSN, use the same account/pw and get _only_ read-only access to the same tables that the web pages are able to insert/update.
I suppose the asp route adds the ADO layer but the question remains as to why Access would allow the account only limited access.
[...pause...]
jeeze...i've just gone over there to reproduce whatever dialog box response i'd gotten when typing in the bottem row...and _now I can't reproduce any of the behaviors. [sigh] later today I'll take smoe time to create a new db from scratch (client-side) and see if the read-only issue reoccurs.
The web stuff is asp...uses a connection string like:
dsn=myDb;uid=not_sa;pwd=th
When linking the table from MSAccess I point to the same DSN, use the same account/pw and get _only_ read-only access to the same tables that the web pages are able to insert/update.
I suppose the asp route adds the ADO layer but the question remains as to why Access would allow the account only limited access.
But it works in query analyser? Hmmm.
It sounds like your connection to the ODBC's. The web stuff that works, is it asp? Are you getting any error messages in Access? If so, where, when and what?
It sounds like your connection to the ODBC's. The web stuff that works, is it asp? Are you getting any error messages in Access? If so, where, when and what?
Featured Post
The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.
One of a set of tools we're offering as a way of saying thank you for being a part of the community.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Why is this different from all of the other step by step guides? Â Because I make a living as a DBA and not as a writer and I lived through this experience.
Defining the name:
When I talk to people they say different names on this subject stuff l…
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month5 days, 21 hours left to enroll
627 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.