Les Commandes Système SYBASE IQ

1

Procédures système :

 

 

 

Commandes système :

Gestion des espaces de stockage

 

Création d'un utilisateur :

 

Les tables système

Récupérer les chemins physiques des dbspaces :

1> select "rename "+dbspace_name+" to '"+file_name+"'" from sysfile

2> where dbspace_name <> 'SYSTEM'

3> go

select name from sysobjects where type='S' order by 1

 

sys.sysservers

 srvid srvname    srvclass srvinfo                           srvreadonly
-----------------------------------------------------------------------

sys.sysexternlogins

user_id srvid remote_login  remote_password
--------------------------------------------------------

SYSTABAUTH : permet de voir les droits sur les objects (équivalent de sp_helprotect)

Table

Contents

SYSUSERPERM

Database-level permissions and password for each user ID

SYSGROUP

One row for each member of each group

SYSTABLEPERM

All permissions on table given by the GRANT commands

SYSCOLPERM

All columns with UPDATE permission given by the GRANT command

SYSDUMMY

Dummy table, can be used to find the current user ID

SYSPROCPERM

Each row holds one user granted permission to use one procedure

View

Contents

SYSUSERAUTH

All information in SYSUSERPERM except for user numbers

SYSUSERPERMS

All information in SYSUSERPERM except for passwords

SYSUSERLIST

All information in SYSUSERAUTH except for passwords

SYSGROUPS

Information from SYSGROUP in a more readable format

SYSTABAUTH

Information from SYSTABLEPERM in a more readable format

SYSCOLAUTH

Information from SYSCOLPERM in a more readable format

SYSPROCAUTH

Information from SYSPROCPERM in a more readable format