resolving permission conflicts

I have been trying to set up permissions for a SQL user ID
on a specific table. The user will access this table using
MS Access 2000 with a standard ODBC connection. I only
want the user to be able to view data from this table.
When I set up a user role in SQL associated with this
user, the permissions on this role are set to deny insert,
update and delete capabilities. This does not appear to
work. However, if I change the permissions on the public
role to deny insert, update, and delete capabilities this
works.
I know every user assumes the public role but I can't seem
to override the permissions set on the public role.
The SQL books online documentation states that a denied
permission always takes prcedent. I cannot seem to make
this work when I have a specific role for this user which
has the deny permissions set.
Thanks,
Jim d'HulstIs the user perhaps an admin on the server and thus inheriting sysadmin via
the Builtin\System role created by default? ( I normall remove this pretty q
uickly)
Alicia
www.sqlporn.co.uk|||Alicia, the user is jnot an admin on the server nor does
this SQL user id belong to any system administration roles.
What I find is if I use windows NT authentication and
assign the permissions the a windows users it works fine.
It is just when I use a SQL user ID that this doesn't seem
to work.
Thanks,
Jim
>--Original Message--
>Is the user perhaps an admin on the server and thus
inheriting sysadmin via the Builtin\System role created by
default? ( I normall remove this pretty quickly)
>Alicia
>www.sqlporn.co.uk
>.
>|||Jim,
Overriding public should be quite doable. Since it is working for your
domain account, I would expect it to work for a SQL account as well. With
all due deference, I suggest that it is probably something simple, but just
hard to see. Silly possibilities:
There is a guest account and the user name is misspelled such that the user
comes in as guest.
The user is also in the db_owner role for the database.
Russell Fields
"jim.dhulst@.am.dynonobel.com" <anonymous@.discussions.microsoft.com> wrote in
message news:fba601c43e7d$96ba1c70$a301280a@.phx.gbl...[vbcol=seagreen]
> Alicia, the user is jnot an admin on the server nor does
> this SQL user id belong to any system administration roles.
> What I find is if I use windows NT authentication and
> assign the permissions the a windows users it works fine.
> It is just when I use a SQL user ID that this doesn't seem
> to work.
> Thanks,
> Jim
> inheriting sysadmin via the Builtin\System role created by
> default? ( I normall remove this pretty quickly)

Resolving a many-to-many relationship

This question isn't specific to SS2000, but since there are many here
familiar with database design I thought I'd ask anyhow.
Imagine these two tables for a company's database in which several
salespeople work together on any particular order:
Salespeople (EmployeeID, Name, Location)
Orders (OrderID, items ordered, salespeople involved)
I realize there are problems with repeating groups, but what I'm interested
in is resolving the many-to-many relationship. Each salesperson gets credit
for many sales, and each sale has many salespeople associated with it.
That's a many-to-many relationship, right? As I understand things, a
"composite table" is needed to break down the one many-to-many relationship
into 2 one-to-many relationships. Am I right so far?
I'm stumped as to what composite table I need. Any ideas?
JoshYou could create a table that would store the EmployeeID and the =OrderID. These columns would be the composite primary key and they =would be foreign keys to the respective tables.
-- Keith
"Josh Meyer" <jmeyer@.msg.ucsf.edu> wrote in message =news:uqLjbh1YDHA.3444@.tk2msftngp13.phx.gbl...
> > > This question isn't specific to SS2000, but since there are many here
> familiar with database design I thought I'd ask anyhow.
> > Imagine these two tables for a company's database in which several
> salespeople work together on any particular order:
> > Salespeople (EmployeeID, Name, Location)
> Orders (OrderID, items ordered, salespeople involved)
> > I realize there are problems with repeating groups, but what I'm =interested
> in is resolving the many-to-many relationship. Each salesperson gets =credit
> for many sales, and each sale has many salespeople associated with it.
> That's a many-to-many relationship, right? As I understand things, a
> "composite table" is needed to break down the one many-to-many =relationship
> into 2 one-to-many relationships. Am I right so far?
> > I'm stumped as to what composite table I need. Any ideas?
> > Josh
> > >

Reset page # after a "specific" group

http://blogs.msdn.com/chrishays/archive/2006/01/05/ResetPageNumberOnGroup.aspx
the above custom code works when reset is needed on change of each
group, How do I modify this code to reset pagenumber after a particular
group say "group 3".Shared offset as Integer
Shared currentgroup as Object
Public Function GetGroupPageNumber(group as Object, pagenumber as
Integer) as Object
If Not (group = currentgroup)
offset = pagenumber - 1
End If
Return pagenumber - offset
End Function
The above code works!
googlerptgsvcs wrote:
> http://blogs.msdn.com/chrishays/archive/2006/01/05/ResetPageNumberOnGroup.aspx
> the above custom code works when reset is needed on change of each
> group, How do I modify this code to reset pagenumber after a particular
> group say "group 3".sql

ReportWizard.vsz

Is there a way to modify the reportwizard.vsz file to use a specific report.rdl file instead of the report.rdl file found in

C:\Program Files\Microsoft SQL Server\80\Tools\Report Designer\ProjectItems\ReportProject

Basically I want to add multiple wizards and point each of them to a different report.rdl file. Any help is appreciated.

Thanks --devin

Sorry, this is not possible. The path to Report.rdl is hardcoded into the wizard.

-Albert

|||Figured. Thanks for your help.

ReportViewer: Show toggle for specific item in a list??

Hello,
Wondering if anyone has any ideas about this:
I have ReportViewer on an ASP page with a report that has a list. The
list shows me rows and I want to be able to toggle just one of the
items in the list based on the type of item it is. Currently I can
only show the toggle icon for all the list items, like this:
+Item1
+Item2
+Item3
But I want the report to show only this:
Item1
+Item2
Item3
I've tried all manner of IIF formulas but none work. Is this even
possible?
ThanksPlease, does anyone have any experience with this?
On Mar 13, 6:11 pm, phrankbo...@.hotmail.com wrote:
> Hello,
> Wondering if anyone has any ideas about this:
> I have ReportViewer on an ASP page with a report that has a list. The
> list shows me rows and I want to be able to toggle just one of the
> items in the list based on the type of item it is. Currently I can
> only show the toggle icon for all the list items, like this:
> +Item1
> +Item2
> +Item3
> But I want the report to show only this:
> Item1
> +Item2
> Item3
> I've tried all manner of IIF formulas but none work. Is this even
> possible?
> Thanks