Re: Permission problems user can't create a table

Thanks again, I guess then that even though a users default schema is
say the dbo schema it doesnt automatically mean they have permissons
on that schema. If for example i wanted to give a user the rights to
create a table in a schema but didnt want to run the Authorization
command (i'm guessing this command makes the user/role owner of that
schema) is there a way

Thanks
Fran


.

Relevant Pages

  • Re: Execute stored procedure via web method.
    ... The only thing I might add is that you can generate a class named Command ... from this schema that lets you bypass any need to directly manipulate XML ...
    (microsoft.public.dotnet.framework.webservices)
  • Re: Need help importing / exporting a schema
    ... command to dump the ... entire schema to a text file. ... You should NOT extrapolate previous experience on other DBs to Oracle. ... provide text SQL schemas is to make it maximally difficult to change ...
    (comp.databases.oracle.misc)
  • RE: Exchange 2000 and Server 2003 issue
    ... Exchange 2000 Schema Changes Are Installed Before You Run the ... Windows Server 2003 adprep /forestprep Command ... Modify replace: lDAPDisplayName lDAPDisplayName: msExchHouseIdentifier ...
    (microsoft.public.exchange2000.general)
  • Re: Schema Question
    ... I used that command you gave me and it came up with the following for 1016 ... >> program extends the schema but I am receiving an error message. ...
    (microsoft.public.win2000.active_directory)
  • Lazy filling a large dataset
    ... is it possible to fill a dataset such that it can be done in increments? ... if I have a large table with a big schema (like 50 columns - ... could I fill a dataset table with a partial query like ... to display in a grid, then when wants details, use a different command on ...
    (microsoft.public.dotnet.framework.adonet)