Restrict Printing based on User?

Is there any way to restrict certain users from printing a report (or
even exporting it)?
If so, what is the difficulty level on a scale of 1-10? I received a
request from a user to prohibit some users from printing, but I would
argue that if you don't want them to print it, they probably shouldn't
even see it.
Still, I'm curious as to the feasibility.
Thanks,
MikeNot with Report Manager. You can remove certain export types but it is for
everybody. Same thing with the new printing control, everybody or nobody.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bassist695" <Michael.EJ.Reynolds@.gmail.com> wrote in message
news:1122382697.120430.226760@.g47g2000cwa.googlegroups.com...
> Is there any way to restrict certain users from printing a report (or
> even exporting it)?
> If so, what is the difficulty level on a scale of 1-10? I received a
> request from a user to prohibit some users from printing, but I would
> argue that if you don't want them to print it, they probably shouldn't
> even see it.
> Still, I'm curious as to the feasibility.
> Thanks,
> Mike
>|||If you allow users to view your reports, you can't prevent them from
printing them.. Even if you find a way to do that, they'll still be
able to use "Print Screen" and then print out the screenshot...

Restrict certain characters in varchar column

Hi - Is it possible to restrict the domain of a varchar column to
prevent certain chatracters being accepted. I want to prevent commas.
ThanksYou could use a check constraint:
alter table <table>
add constraint <constraint name>
check (patindex('%,%', <column> ) = 0)
go
ML
http://milambda.blogspot.com/|||hals_left (cc900630@.ntu.ac.uk) writes:
> Hi - Is it possible to restrict the domain of a varchar column to
> prevent certain chatracters being accepted. I want to prevent commas.
ALTER TABLE tbl ADD CONSTRAINT nocommas CHECK col NOT LIKE '%,%'
Then again, this sounds like a somewhat strange business rule. Semicolons,
periods, colons etc are OK, but not commas? What is the real story?
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||>What is the real story?
When I pass CSV strings to a stored proc, a comma inside a value causes
a problem.
I will re-write the split code to use some other character|||Dejan Sarka posted a very nice function that you might find use for:
http://solidqualitylearning.com/blo.../10/22/200.aspx
ML
http://milambda.blogspot.com/sql

Restrict access to certain db

I need to install EM and QA on some users machines, but I only want them to
have access to certain db's, What is best way to manage this? ALso, in QA I
want them to only be able to run Select/Update/Make Table queries. How do
I force a user to logon whe
n they open EM or QA with a certain login account?Hi,
1. Create a new login in sql server (Use enterprise manager -- Security
option)
2. Go to database and select users option and add a new user
3. Assign that user db_reader and db_writer role (this will only allow that
user to browse and update/insert/delete contents in this database)
4. Login to QA as SA user
5. Select the database in which the user need create table prev.
6. Execute "Grant CREATE TABLE to <User name>
If you need to restrict the Insert and Delete from tables - Have a look into
DENY command .
Tahnks
Hari
MCDBA
"mikeb" <anonymous@.discussions.microsoft.com> wrote in message
news:AAC88C32-6D4C-44C8-B6D8-607F078F6A7A@.microsoft.com...
> I need to install EM and QA on some users machines, but I only want them
to have access to certain db's, What is best way to manage this? ALso, in
QA I want them to only be able to run Select/Update/Make Table queries. How
do I force a user to logon when they open EM or QA with a certain login
account?

Restoring just a table from a full backup

is there a way to restore certain tables from a full backup?

Simple answer: No

Although there might be a way if you used a seperate file group for that table.

|||I am not sure. We are using Great Plains 9 and my bose told me he just wants to backup and restore payroll.|||

try some 3rd party tools.

|||You can restore the backup with other name, then copy the desired table from one database to the other.|||great idea|||I believe that is what I will do. thanks.|||

When you use for example SQL LiteSpeed for dumping (also usefull for quick and compressed dumping) there is an option in the admin tool for SQL LiteSpeed where you can restore a single object (view, sp, table, function etc) from a dump.

I have very good experience with SQL LiteSpeed.