How to disable a user to "Generate SQL Script..."

I have an SQLServer 2000 instance with a DataBase.
I have 2 users: sa, new_user.
The [new_user] has membership role: public, db_datareader, db_datawriter
It has permissions to manipulate some table and stored procedures. He can
not export, import, backup, restore the data base.

The point is that he can generate a script for the all database!!!
How do I disable it?
Can some one give me some help on this issue.

Thanks,

Dont allow your users to have Enterprise Manager, much less the Login
information, and the problem will go away.
--
TIA,
ChrisR


"Joao Rego" wrote:

> I have an SQLServer 2000 instance with a DataBase.
> I have 2 users: sa, new_user.
> The [new_user] has membership role: public, db_datareader, db_datawrit
er
> It has permissions to manipulate some table and stored procedures. He can
> not export, import, backup, restore the data base.
>
> The point is that he can generate a script for the all database!!!
> How do I disable it?
> Can some one give me some help on this issue.
>
> Thanks,
>

Tks for the tip, but the point is that the user is a freelancer developer
that need to see tables and stored procedures... I just want to protect my
data base from beeing copied.

tks anyway,
Joao

"ChrisR" wrote:

> Dont allow your users to have Enterprise Manager, much less the Login
> information, and the problem will go away.
> --
> TIA,
>     ChrisR
>
>
> "Joao Rego" wrote:
> 

Joao,

You've already given the developer the ability to read and write to every
table so.  Might want to disallow this and GRANT only the object permissions
that the developer requires to do his job rather than giving the developer
full access to all of the tables.

HTH

Jerry
"Joao Rego" < JoaoRego@discussions
.microsoft.com> wrote in message
news:224ACDD7-DDA2-424D-BA8D- C22A9EDBDE03@microso
ft.com...
> Tks for the tip, but the point is that the user is a freelancer developer
> that need to see tables and stored procedures... I just want to protect my
> data base from beeing copied.
>
> tks anyway,
> Joao
>
> "ChrisR" wrote:
>